Reporting with Dynamics CRM 2015 and the new Power BI Designer 07 May 2015 Jurgen-Postelmans This article will show how you can use the new Power BI Designer to create Power View reports on top [More]
Dynamics CRM 2013 and Power BI for Office 365 - Part 2 05 February 2014 Jurgen-Postelmans In the first part of this blog post we used Power Query to create the following Data Model in Excel. As you can see the relationship between the 2 tables is still missing and we would also like to define a Hierarchy in QueryFromContact. And although we could have done this in Power Query itself we w... [More]
Dynamics CRM 2013 and Power BI for Office 365 - Part 1 05 February 2014 Jurgen-Postelmans In this blog post we will have a look at how you can use Power Query to create a Power Pivot data model in Excel and publish it to a Power BI site in Office 365. Once the Excel file with the Power Pivot data model is in Power BI for Office 365 we can query it with Power Q&A. If you have... [More]