Both clients and developers were waiting for this feature ever since the Power BI embedded personal dashboards were introduced in the Dynamics 365 and Model-Driven apps. Till now, we were using various tricks to embed a power bi report and dashboard in as a system dashboard but finally, we have the out-of-the-box feature to do the same.
Power BI embedded dashboard feature enables developers to add a reference to an online Power BI report or dashboard as a system dashboard. This is then available to all users through the standard dashboard page selector.
Like any other system dashboard, security can restrict access to certain users.
Users need to have the relevant Power BI license and authorization to consume content.
To add a power bi embedded dashboard we need to:
1. Create a system dashboard with Power BI embedded
2. Add that Power BI embedded dashboard to a model-driven app
Create a system dashboard with Power BI embedded
- Navigate to the Solutions area in make.powerapps.com, and then create or open an existing solution.
- Select New > Dashboards > Power BI embedded (preview).
- Create the dashboard of type Power BI report or dashboard.
- Save and Publish this new dashboard.
Add a Power BI embedded dashboard to a model-driven app
- Create or edit an existing model-driven app using the app designer.
- Select the Dashboards subarea on the app designer canvas.
- On the dashboards property pane, there is a Power BI embedded dashboards category. Add the relevant dashboards.
- Save and Publish the app.
Power BI embedded in a system dashboard or form ignores the Power Platform admin center Power BI visualization embedding environment setting.
That setting controls whether end users can add embedded Power BI reports to personal views, charts, and dashboards.
Create a Power BI embedded dashboard with an environment variable
To deploy the dashboard into multiple environments, we can use Environment Variables to allow each environment to reference a different workspace. For each environment, you specify the workspace and either a dashboard or report to reference. To do this:
- Create or edit an existing Power BI embedded system dashboard.
- Select Use environment variable.
- Open the Power BI environment variable selector and then select New environment variable.
A nested panel opens where you create the environment variable. The environment variable properties are automatically filled using the dashboard Display Name and Name. You can configure the workspace and report or dashboard. The values are stored as JSON. - Save the environment variable. The default and current values for workspace and report or dashboard are displayed.
Well, I hope everyone would be excited to use this feature soon for our customers. As it is in the Preview mode, we can expect some changes in future before release.
Till next time, Cheers 😉
good to see the ALM around this stuff finally coming along