- Using Microsoft Power BI Desktop to build Dynamics CRM Online reports – Part 1 – Introduction
- Using Microsoft Power BI Desktop to build Dynamics CRM Online reports – Part 2 – Using option sets in reports
- Using Microsoft Power BI Desktop to build Dynamics CRM Online reports – Part 3 - Relationships and the map control
- Using Microsoft Power BI Desktop to build Dynamics CRM Online reports – Part 4 – Sharing and collaborating
- Using Microsoft Power BI Desktop to build Dynamics CRM Online reports - Part 5 - Refreshing data and custom visuals
Another interesting update was the release of support for R in June 2016 – see R for the masses with Power BI. To get started with R in Power BI – you can download the Power BI sample with correlation plot in R which uses the rrplot package. Power BI Desktop does not include, deploy or install the R engine. I installed RStudio, the sample Power BI project uses the corrplot package, so you will first need to install this package using the R console prompt in RStudio.
Definitely check out the Create Power BI visuals using R guide (Don’t forget to take at the current limitations in R at the end of the post) and Getting started with R Visuals in Power BI to get started – afterwards you definitely need to take a look at the Welcome to the R script showcase Power BI Gallery to see some interesting examples that you can use.
Listed below is an example of how you can use decision trees in Power BI with R to visualize the probability of something you want to estimate, based on historical data – the sample project uses data about the survival statistics of passengers of the Titanic. The decision tree classifier automatically finds the important decision criteria (or features) to consider which can help you can in making decisions. Decision trees are a form of multiple variable (or multiple effect) analyses. An example of a multiple variable analysis is a probability of sale or likelihood to respond to a marketing campaign as a result of the combined effects of multiple input variables, factors or dimensions.
In July 2016, Power BI Embedded also reached general availability – Power BI embedded allows ISVs to provide the richness of Power BI to customers within their specific multi-tenant applications. This can for example be an Azure hosted web application in which an ISV wants to embed fully, interactive reports built using Power BI. For more information check out Your data. Your visualizations. Your way – with Power BI – which explains the difference between Power BI Embedded and standard Power BI – as well as What is Microsoft Power BI Embedded? Power BI also allows you to embed Power BI tiles in Dynamics 365 dashboards – see Display Power BI visualizations in Dynamics 365 dashboards or Add or Edit Power BI visualizations on your dashboard for some walkthroughs.
Another important change is the endpoint that you need to use when connecting Power BI directly to Dynamics CRM 365 – from Dynamics CRM version 8.1 onwards (so also for Dynamics 365) you should use the OData endpoint URL and not the OrganizationService SOAP service even though the dialog still shows it as an example – the documentation Use Power BI with Microsoft Dynamics 365 (Technet) has already been updated for this change.
To get an overview of what has been released and what is under development around Power BI for Dynamics 365 - you can also take a look at the roadmap for the updates which have been recently released or which are under development - https://roadmap.dynamics.com/
- Power BI Desktop – 2016 Year in Review
- Announcing the sales management solution template for Dynamics 365 with Data Export – Data Export is a free add-on service which allows you to replicate Dynamics 365 data to a Microsoft Azure SQL database store. The new Power BI template allows you to connect to the Azure SQL.
- Quickly create infographics with the infographic designer custom visual for Power BI
- Pareto charts in Power BI
- Using Power BI to make stunning Twitter campaign dashboards
- Microsoft Power BI webinars overview
- Explore and analyze your Infer data with Power BI
- Power BI and AzureML better together
- Power BI Insights and Analytics for Everyone: Natural Language Search, Quick Insights and Cortana
- Example reports for Power BI in insurance
- Gap Analysis visual for Power BI
- KPI indicator custom visual for Power BI Explained
- Free e-book: Introducing Microsoft Power BI
- Power BI Architecture Diagram V2
- Visual awesomeness unlocked – waffle chart
- Gather intelligence in Dynamics CRM with Power BI and Cortana Intelligence (Ignite session recording)