Recently we had a requirement to show existing PowerBI dashboards in Dynamics 365.
When we tried to create a Power BI dashboard in dynamics, we couldn’t see the “New PowerBI dashboard” option on Dashboards page.
The problem was the PowerBI dashboards feature in Dynamics has to be enabled before we can go ahead and add a dashboard.
This is how to enable it:
- Sign-in to Microsoft Dynamics 365 as a user with the system administrator security role.
- Go to Settings > Administration > System Settings.
- On the Reporting tab in the Allow Power BI visualization embedding option, select Yes to enable.
- Click OK.
Once you are done, refresh the Dashboards page and you should now be able to see the Add new button.
Note: To access PowerBI dashboards in Dynamics, the users would need Power BI pro license. Exception being if customer has power BI premium, in that case only users creating power bi reports need to have power bi pro licenses.