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 SQL Server 2012 SP1 Version of ADOMD.NET is Required for Analysis Services Power Query Connector
In its recent post announcing November release of Power Query, Microsoft is also asking us to take a Power Query survey. I have lobbied for a long time to have SAP BW added to the supported PQ data sources. The reasoning is simple, almost half large companies in US run SAP and a good percentage … Continue reading Vote to Add SAP BW as Power Query Data Source
Let's take a look at an unfortunately very familiar to most of us business scenario. A patient gets admitted to a hospital, spends several days there and then gets discharged (hopefully feeling much better 🙂 ). In this situation, we have two dates that describe this event, the date of being admitted and the date … Continue reading Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)
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 Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?