Download | Source



Power BI is the best tool for visualising your business data. As a customer of Dynamics 365 Customer Engagement you obviously want to take advantage of Power BI inside your dashboards and forms.

Today Dynamics 365 CE support showing Power BI reports and dashboards in your personal dashboards. But the functionality is limited.

The goal of crm-powerbi-viewer is to deliver as much of the Power BI functionality inside Dynamics 365 as possible.

Below is a list of enhancements provided by crm-powerbi-viewer that for the time being is not available by using the built-in PowerBI integration in Dynamics 365.


Enhancements:

  • Solution aware. Embed Power BI to any dashboard (not only personal)
  • Embed Power BI to both dashboards and forms
  • Works with Dynamics 365 on-premises
  • Supports opening reports on a specific page
  • Support for custom filters and interactions. Enabling:
    • Open related Dynamics 365 records when clicking on data in a report (or visual)
    • Filter reports on Dynamics 365 data (e.g. filter on account id when showing reports on an account form)
  • Hide report navigation and filter panes
  • Mix and match multiple Power BI elements with Dynamics 365 elements on a single dashboard/form
  • Embed Power BI:
    • Dashboards
    • Single tile from a dashboard
    • Reports
    • Single visual from a report (new in v1.1)









Installation

Prerequisits

You have of course already created a Power BI report or dashboard with tiles you want to embed into your Dynamics 365 instance? If not go ahead and do that now. You should create your content in a Workspace for easy sharing with users of Dynamics 365.

As the solution needs to authenticate users against Power BI you need proper rights to add an application to your Azure Active Directory (AAD). Without such rights you will not be able to make this work. Reach out to your Azure or Office 365 Admin if you do not have the proper rights.

Installation steps:

1 Add crm-powerbi-viewer as an application in Azure AD (or try the alternative simpler flow)
2 Install and configure crm-powerbi-viewer in Dynamics 365 Sales and Service

Not working as expected? Have a look at troubleshooting.


Basic Configuration

The guide below describe how to add Power BI elements to Dynamics 365 Dashboards.

Dashboard Add a Power BI View to a CRM Dashboard


Note The same steps apply to embedding into CRM Forms.


Advanced Configuration - filtering, click-handling, …

Filtering and handling click-events require some javascripting - how much depend on what you want to achieve. The guide below provides a brief introduction and links to more information when you want to take it to the next step.

Adv Advanced Configuration