This information has been around the blogosphere for a while but I keep forgetting how to find it; I decided to write about it on my blog so that I can easily find it next time I need it. The existing functionality of the Power BI Connector for SAP BW only exposes text values of … Continue reading How to Expose Key Values from SAP BW in Power Query
Category: Power Query
SAP BW Support for Power BI is PLANNED!
It is very unfortunate that at the time when there is such a flood of good and exciting news coming out from the Power BI dev team my workload made it almost impossible to post on this site. However, a recent update from the Power BI support site made me literally drop everything and write … Continue reading SAP BW Support for Power BI is PLANNED!
Power BI Designer Now Connects to Google Analytics… Power Query Doesn’t
I am sure it is only a matter of days (hours ?) before Power Query is updated with the Google Analytics connector as well, but I find it very interesting that new Power Query features are now first released in Power BI Designer. I had speculated earlier that Microsoft would/should focus on Designer as the … Continue reading Power BI Designer Now Connects to Google Analytics… Power Query Doesn’t
Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report
Click here to download the data file for this tutorial. We are not always lucky to have our data neatly laid out in rows and columns. Sometimes, our data come in as a formatted report and we need to find a way to massage the data before it can be loaded into a data model. … Continue reading Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report
Power BI Tutorial: Generate ID field using Power Query
This tutorial is based on one of the earlier tutorials – How to Create a Star Schema Model. I strongly recommend that you go through it first to become comfortable with using Power Query to create facts and dimensions for your Star schema before we start working on ID generation. The data set that we'll … Continue reading Power BI Tutorial: Generate ID field using 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 SQL Server 2012 SP1 Version of ADOMD.NET is Required for Analysis Services Power Query Connector
Vote to Add SAP BW as Power Query Data Source
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
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 Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
business intelligist 