Musings on Data
A blog for data, apis, and all things Power BI by Lukasz Pawlowski.
New York Public Library Digital Collection in Power BI
Some time ago I saw news that the New York Public Library has published its digital collection on...
Author: Lukasz Pawlowski -- MS Date: 06/19/2016
Working with JSON data in Power BI Desktop's query tab
I'm helping some journalists get up to speed with Power BI and walking them through how to load...
Author: Lukasz Pawlowski -- MS Date: 04/17/2016
Basic DAX filtering with CALCULATE and ALL functions
Recently I helped a few reporters get their first taste of building reports using Power BI. Power BI...
Author: Lukasz Pawlowski -- MS Date: 04/09/2016
#VisualizeChange - Comments in Words
Recently a retweet from @olivier_matrat came through my twitter feed and it struck a chord. It was...
Author: Lukasz Pawlowski -- MS Date: 08/25/2015
Visualizing London's open data in Power BI
Today we're visiting London, UK. In previous posts, I've looked at data from Seattle and Chicago....
Author: Lukasz Pawlowski -- MS Date: 08/08/2015
Finding the Latest Date in Power BI Desktop
One common question I get is how to do date filtering in Power BI. In a previous post, I showed how...
Author: Lukasz Pawlowski -- MS Date: 08/08/2015
Don't miss out - See Power BI in action at the Ignite Expo Hall
Folks, Spread the word. Dawn, our amazing event coordinator, has put together an 'A' list of quick...
Author: Lukasz Pawlowski -- MS Date: 05/03/2015
Power BI Dynamic Date Filtering
One question I get from time to time is how to filter to the last week's worth of data automatically...
Author: Lukasz Pawlowski -- MS Date: 03/05/2015
Seattle Building Permits visualized in Power BI with Socrata OData and data.seattle.gov
Living in Seattle, it’s quite fun to keep track of what’s happening through data. The...
Author: Lukasz Pawlowski -- MS Date: 02/22/2015
Power BI Designer Preview February 2015 update now available
Power BI Designer Preview is a standalone tool for building reports for Power BI. I'm using it...
Author: Lukasz Pawlowski -- MS Date: 02/19/2015
Year over Year in DAX - SAMEPERIODLASTYEAR needs a filter scope
This week I'm working to create a measure to count the total commits in a repository. I thought it...
Author: Lukasz Pawlowski -- MS Date: 02/16/2015
Power BI and GitHub
Scott Hanselman has a great blog post showing how he got up and running with Power BI using the...
Author: Lukasz Pawlowski -- MS Date: 02/04/2015
Power BI - Excel sheet data needs Excel Tables
I've not written a blog post in far too long. Now with the preview of Power BI as a free service...
Author: Lukasz Pawlowski -- MS Date: 02/03/2015
SQL 2008 R2 RTM! Time to look at some new Execution Log Reports
Wow. We just RTM’ed SQL Server 2008 R2. Check out the official web site SQL Server 2008...
Author: Lukasz Pawlowski -- MS Date: 04/22/2010
Charts in a Tablix cell don’t work for me… but I’ve see these nice demos where they do…
Problem: You may have learned about sparklines or you want to add a chart to your Tablix. You...
Author: Lukasz Pawlowski -- MS Date: 12/21/2009
High Availability – Frequently Asked Questions about Failover Clustering and Reporting Services
In SSRS high availability is achieved through a Scale-out deployment that is placed behind a Network...
Author: Lukasz Pawlowski -- MS Date: 10/28/2009
Building a robust setup experience with Reporting Services
This post is intended for ISVs or Product Development organizations who are planning to integrate...
Author: Lukasz Pawlowski -- MS Date: 07/02/2009
InternalCatalogException, ASSERT, or NullReferenceException when using a Custom Security Extension
We have seen multiple customers with issues when customizing the Security Extension Sample (2005,...
Author: Lukasz Pawlowski -- MS Date: 05/08/2009
IIS Troubleshooting for SQL Server 2005 Reporting Services
Over the years, we have seen a number of IIS related issues that cause trouble for users who deploy...
Author: Lukasz Pawlowski -- MS Date: 02/04/2009
Several blogs I would keep on my reading list...
Recently I have had little time to devote to blogging, but I did want to pass along a couple of...
Author: Lukasz Pawlowski -- MS Date: 01/23/2009
SQL PASS Community Summit 2008 Presentation Links
Denny Lee and I presented on Wednesday at the SQL PASS Community Summit 2008 on Building SSRS 2008...
Author: Lukasz Pawlowski -- MS Date: 11/21/2008
SQL Server 2005 Notification Services Components Package RC1 Availability
As part of this blog, I comment about Notification Services. I wanted to provide you the following...
Author: Lukasz Pawlowski -- MS Date: 09/09/2008
SQL 2008 RTM - Where is Report Builder 2.0?
We've just released SQL Server 2008 (it feels great by the way!) and there have already been many...
Author: Lukasz Pawlowski -- MS Date: 08/07/2008
Reporting Services HTTP 401 (Unauthorized) - Host Headers require your attention
In a previous post, I talked about issues with repeated login prompts when trying to access either...
Author: Lukasz Pawlowski -- MS Date: 07/18/2008
SQL Server 2008 Reporting Services Scalability
Much has been said up to now about the scalability work the Reporting Services team has done in the...
Author: Lukasz Pawlowski -- MS Date: 07/14/2008
Solving the Reporting Services Login issue in the February CTP of SQL Server 2008
I’ve seen customers run into authentication issues using the SQL Server 2008 February CTP of...
Author: Lukasz Pawlowski -- MS Date: 03/27/2008
Finding Reporting Services Content faster
Hi everyone - I've been away from my blog for a little while. However, now again I have some time to...
Author: Lukasz Pawlowski -- MS Date: 03/18/2008
Keeping your report servers awake (or No more waiting for report server to startup)
Update 5/3/2010: With time and experience, we learn. So of course an easier way exists to do what...
Author: Lukasz Pawlowski -- MS Date: 09/18/2007
Scale Testing Reporting Services
I wanted to provide a quick note on how to scale test Reporting Services. Partially I'm posting this...
Author: Lukasz Pawlowski -- MS Date: 09/05/2007
Report Viewer Control - Reset() method
This post is about a consequence of the calling ReportViewer.Reset() method related to revaluating...
Author: Lukasz Pawlowski -- MS Date: 08/24/2007
Monitoring Subcription Status - New reports!
A while ago I wrote a blog post to explain how to monitor subscription status. You can read it here:...
Author: Lukasz Pawlowski -- MS Date: 08/01/2007
New Reporting Services Portal on MSDN
Just adding a quick note about the new MSDN Home Page for Reporting Services. It has links to many...
Author: Lukasz Pawlowski -- MS Date: 05/25/2007
Using Multi-Value Parameters Programmatically
It seems there is a ton on confusion about how to programmatically use multi-value parameters....
Author: Lukasz Pawlowski -- MS Date: 04/25/2007
Reliability through isolation
Reporting Services is an example of a system that both handles interactive user load and schedule...
Author: Lukasz Pawlowski -- MS Date: 04/05/2007
Daylight Savings Time issues with Notification Services - update your databases!
With the coming change to Daylight Savings Time in the United States, you will need to update your...
Author: Lukasz Pawlowski -- MS Date: 02/13/2007
How to diagnose issues when running reports in the report server?
A customer came to the SQL Server Customer lab to investigate a problem with one of the feature I’m...
Author: Lukasz Pawlowski -- MS Date: 01/31/2007
Per user snapshots? Or multiple snapshots for a report each with different parameters at the same time
I've received questions in the past about whether the report server supports per user snapshost -...
Author: Lukasz Pawlowski -- MS Date: 01/12/2007
SQL Pass presentation: Management, Configuration, Security
It's been a little while since my last post. I wanted to provide additional information related to...
Author: Lukasz Pawlowski -- MS Date: 11/15/2006
Getting Started with Reporting Services
The question sometimes comes up for how to get out of the gate fast when ramping up on Reporting...
Author: Lukasz Pawlowski -- MS Date: 08/08/2006
IE 7 Beta 3 Issue when viewing reports in Reporting Services
There are a couple of threads on the Reporting Services MSDN Forumn and newsgroup about IE 7 Beta 3...
Author: Lukasz Pawlowski -- MS Date: 07/12/2006
Report Designer for SQL Server 2000 Reporting Services does not work on Visual Studio 2005
Some folks have run into a problem using SQL Server 2000 Reporting Services now that Visual Studio...
Author: Lukasz Pawlowski -- MS Date: 05/23/2006
SQL Server 2005 SP1 Reporting Services database expected version is 'C.0.8.43' problem
(Originally I thought this post should be titled: SQL 2005 SP1 Tattered my Report Server Database –...
Author: Lukasz Pawlowski -- MS Date: 05/18/2006
Upgrading Reporting Services - What about my Report Definitions (RDLs)?
Some folks have asked me what happens when I upgrade my RS 2000 to an RS 2005 deployment with...
Author: Lukasz Pawlowski -- MS Date: 02/20/2006
Populating the Cache before your users pound your report server
Often people take a look at their report execution times and wonder how to optimize it. They readily...
Author: Lukasz Pawlowski -- MS Date: 02/13/2006
I'm famous - no seriously, you can watch a video on Reporting Services and Notification Services upgrade on Microsoft.com
Wanted to share with you the following link. This is a presentation I gave a little while ago on...
Author: Lukasz Pawlowski -- MS Date: 01/25/2006
Monitoring Subscription Status (also calling RS SOAP methods from inside reports)
While posting on the Reporting Services forum, I came across a post by some folks looking to know...
Author: Lukasz Pawlowski -- MS Date: 12/30/2005
Windows SharePoint Services and RS 2005
In RS 2000, users had a lot of grief to get RS to work on the same computer as Windows SharePoint...
Author: Lukasz Pawlowski -- MS Date: 11/21/2005
Community Resources
I've received several emails from folks reading my blog asking for direct assistance with various...
Author: Lukasz Pawlowski -- MS Date: 11/21/2005
Support for RS 2000 RDL in RS 2005
I've started getting questions like the following: Given a report developed on SRS 2000 can that...
Author: Lukasz Pawlowski -- MS Date: 11/08/2005