In the previous article, we saw how to quickly create Power BI Report, in this article we will learn about embedding or displaying those reports (and dashboard) inside Dynamics 365.
This creates a new dashboard and adds the selected report to it.
Now back in Dynamics 365 CE, let us enable Power BI integration. Go to Settings → Administration → System Settings
Enable the Power BI Visualization Embedding option.
Go to Dashboard and click on New → Power BI Dashboard
Select the Workspace – My workspace and the Dashboard.
The Power BI Dashboard inside Dynamics 365
Now, what if we want to share the Power BI Dashboard with other users so that they can also create their Personal Power BI Dashboard inside Dynamics 365 tools. Go back to Power BI home, and click on Share.
We will get the message that Power BI Pro License is required for sharing the report. Click on Try Pro for free to acquire the license. This will be free 60 Day trial.
Once the trial is activated, we can share the report with another user, who can then create a new Power BI Dashboard inside Dynamics 365 CE using this shared report.
Apart from the Dashboard, the Power BI Report can also be embedded inside the normal Dynamics 365 CE Dashboard as a Power BI Tile.
One last point that we need to remember is regarding the Refresh of the data, so that end users are looking at the most up-to-date data. It can be done manually by selecting the DataSet for the report and clicking on Refresh Now as shown below.
The other option is to schedule the refresh by selecting Schedule Refresh option, now as we have enabled the Power BI Pro license we can schedule the refresh to run a maximum of 8 times a day, unlike Power BI Premium. (Which allows 48 times a day)
Thus we saw how easy it is to author a Dynamics 365 CE Power BI Report which is highly interactive and highly customizable in few steps and without writing any single of code and easily embed it within Dynamics 365 CE.