Seattle Building Permits visualized in Power BI with Socrata OData and

  Living in Seattle, it’s quite fun to keep track of what’s happening through data.  The Open Data initiative from the City of Seattle is a treasure trove of information that you can explore here:  This is all power by Socrata, as are many other open data initiatives for Cities and organizations.  I wanted…


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 myself whenever I can to build reports – it has all the new visualizations that the Power BI Preview service ( has, but in a streamlined client tool.  It includes all the Power Query capabilities that are available…


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 was working until I looked at the grand total and found something was off.    For the case of Grand Total, the value was mysterious. These were the measures I was using.  Total commits YoY% old:=DIVIDE([Total commits]-[Total Commits Same Period Last year],[Total…


Power BI and GitHub

Scott Hanselman has a great blog post showing how he got up and running with Power BI using the GitHub content pack.  Great example of how quickly folks can start getting insights on their data in the web or on mobile devices. HTH, Lukasz


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 (try it here:, I wanted to reinvigorate my blog with a few new posts.  As a member of the “customer success team”, I get to see what questions people are asking and offering solutions.  In the last…