Edit

Share via

Create or edit a Power BI embedded system dashboard

  • Article

This article explains how to set up and use a system dashboard that references a Power BI report or dashboard in a model-driven app. System administrators and system customizers can create system reports and dashboards, which can be made available to model-driven app users. Users need to have the relevant Power BI license and authorization to consume content. Read more about relevant Power BI licenses at Power BI pricing.

To learn more about Power BI reports and dashboards, see Create reports and dashboards in Power BI.

Note

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 system dashboard with Power BI embedded

This procedure shows you how to set up a Power BI embedded page for a single environment connected to a Power BI workspace.

  1. Select Solutions on the left navigation pane in make.powerapps.com, and then create or open an existing solution. If the item isn’t in the side panel pane, select …More and then select the item you want.

  2. Select New > Dashboards > Power BI embedded.

  3. If you have the Power BI Extensions (Preview) system solution installed, you can select a solution-aware Power BI report to be embedded in a system dashboard. You'll see the Show reports in this environment only option selected, and the dedicated environment Power BI workspace is pre-selected for you.

    Important

    Show reports in this environment only option

    If you clear Show reports in this environment only, you can select a Power BI report or a Power BI dashboard from another workspace.

  4. Enter the following information in the New Power BI embedded dialog that appears:

    • Enter a Display name for the dashboard, which will be shown to the user in the selector on the Dashboards page.
    • Select the type, either Power BI report or Power BI dashboard.
    • Select Use environment variable if you want to replace a static workspace and report to use an environment variable from configuration. More information: Environment variables overview
    • Select a Power BI workspace.
    • Select a Power BI report or dashboard.

      New Dashboard Power BI embedded panel.

  5. Select Save to save and publish the system dashboard.

Add a Power BI embedded page to a model-driven app

  1. Create or edit an existing model-driven app using the app designer.

  2. Select the Dashboards subarea on the app designer canvas.

  3. On the dashboards property pane, there is a Power BI embedded page category. Clear All to select specific dashboards. Optionally, the Power BI embedded page can be set as the default dashboard in the site map.

    App designer dashboards Power BI embedded category.

  4. Open Site map from the app designer, then select the existing Dashboards subarea or insert one.

  5. Open the Default Dashboard property and then select the Power BI embedded dashboard name.

    Site map designer subarea property default dashboard.

  6. Select Save. To make your changes available to users, select Publish.

Select the Power BI embedded page in the model-driven app

  1. Play the model-driven app, and then select a dashboard from the left navigation pane.

  2. Open the dashboard selector and select the Power BI embedded page.

Create Power BI embedded page with an environment variable

When a solution with a Power BI embedded component will be moved to other environments, you can turn on Use environment variable to configure the dashboard. For each environment, you specify the workspace and either a dashboard or report to reference. Environment variables allow configuration without unmanaged customizations.

  1. Create or edit an existing Power BI embedded system dashboard.

  2. Select Use environment variable.

    Use environment variable.

  3. Open the Power BI environment variable selector and then select New environment variable.

    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. More information: Environment variables overview

    Power BI embedded Environment Variable panel.

  4. Save the environment variable. The default and current values for workspace and report or dashboard are displayed.

    Power BI embedded environment variable value preview.

See also

Create or edit model-driven app dashboards
View table data in Power BI Desktop
Use Power BI
Use Power BI with Microsoft Dataverse
Create a Power BI report using the Common Data Service connector