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...
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 09/05/2007
Report Viewer Control - Reset() method
This post is about a consequence of the calling ReportViewer.Reset() method related to revaluating...
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:...
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...
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....
Date: 04/25/2007
Reliability through isolation
Reporting Services is an example of a system that both handles interactive user load and schedule...
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...
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...
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 -...
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...
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...
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...
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...
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 –...
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...
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...
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...
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...
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...
Date: 11/21/2005
Community Resources
I've received several emails from folks reading my blog asking for direct assistance with various...
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...
Date: 11/08/2005