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

Visualizing City of Chicago owned properties with Power BI Designer

Update 8.9.2015: Title updated with new product name The week after next, I’ll be in Chicago...

Author: Lukasz Pawlowski -- MS Date: 04/26/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

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

Next>