Loading multiple JSON files using Power Query
I had to figure out recently how to load multiple JSON files using Power Query. It turned out to be less easy than expected, so I figured it is worth blogging about… The scenario: I have multiple…
Walkthrough: how to connect to Dynamics CRM Online with Power BI
In this walkthrough I will step through the process of connecting to a Dynamics CRM Online instance with Power BI (specifically Power Query). For this you will need to latest version of Power Query installed. After you…
New Power Query update
Recently a Power Query update was released (see http://blogs.office.com/2015/03/05/3-updates-excel-power-query/). Mayor updates: performance on load, Dynamics CRM Online connector and new transformations, most notably advanced date/time calculations. Personally I enjoy the CRM Online connector, but I am most fond of…
Power BI connectivity to Salesforce.com
Here is a short video on how to connect to Salesforce.com from Power BI: You can now easily get data from Salesforce.com into your Excel / Power BI solution. Enjoy!
Power BI connectivity to SAP Business Objects Universe
Here is a short how-to video on how to connect to SAP Business Objects Universe through Power BI: Enjoy!
Power BI Pro Tip: Dealing with errors when reading Excel files
If you use Power Query to read an Excel file that has errors (such as #VALUE, #REF, #N/A, etc) the rows that contain the error will not be loaded into the data model but instead will be…
Power BI pro tip: using Access Online for data entry
With powerful self-service BI tools such as Power BI comes the need for business user data entry; data does not exist in source systems or does need to be enhanced / enriched before going into the report,…
Combining text (csv) files using Power Query – follow-up
I have been getting quite a few responses on my original post on how to combine text (csv) files using Power Query. One of the FAQs is how to keep the filename where the data came from…
Analyzing Amsterdam Crime Rates with Power BI
Here is another example of what can be done with Power BI. This time I attempted to analyze crime rates in Amsterdam. I retrieved burglary and burglary attempts figures from the Dutch Police website: http://www.politie.nl/misdaad-in-kaart/lijst?geoquery=amsterdam&categorie=1&categorie=2&pageSize=500&page=1 There are…
Top 3 of what is new in Power Query for Excel
Just recently the December update of Power Query for Excel has been published. See this blog post on the Power BI for the details: http://blogs.msdn.com/b/powerbi/archive/2013/12/13/one-step-closer-to-simplifying-data-analysis-and-visualization-new-features-added-to-power-bi-for-office-365-and-power-query-add-in-for-excel-preview.aspx. In this post I want to give you my personal top 3:…