Category: Power Query

SAP BW Connector for Power BI – Support for additional member properties

October update of Power BI Desktop was released a couple of days ago. One of the key feature update in this release is that the SAP BW Connector now supports additional member properties (attributes). Earlier version of SAP Connector exposed only text value of the BW object. To get additional member properties, we had to have

Continue reading

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