Category: Power Query

SQL Server 2012 SP1 Version of ADOMD.NET is Required for Analysis Services Power Query Connector

Understandably, I was very excited to find Analysis Services as a supported Power Query data source as of November update of the product (those familiar with the Business Objects connector will find the interface to be very familiar). I am running SQL Server 2014 on my machine and have the corresponding version of the ADOMD.NET

Continue reading

Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query

Click Here to download this Tutorial file Very often our analysis starts with a flat data set that contains all of the pertinent columns in a single table that looks like the one above. As we can see, we can analyze this data using three different lenses or dimensions: Product Geography Date Unfortunately, if we

Continue reading