Add Power BI

You can add Power BI component on a page to display Power BI dashboards and reports on your portal.

Note

Before you begin, read Power BI access type considerations and general Power BI considerations to get familiar with important Power BI terms and considerations for Power Apps portals.

To add a Power BI component to a web page:

  1. Edit the portal.

  2. Select the page to add a component to.

  3. Select an editable element on the canvas.

  4. Select Components from the left side of the screen.

  5. From Portal components section, select Power BI. The Power BI placeholder is added to the canvas:

  6. In the properties pane on the right side of the screen, enter the following information:

    1. Access type: Select appropriate option from the drop-down as per your requirement.

      Power BI Access type

      1. Embed for your customers - Allows you to securely share the Power BI dashboards or reports to external users without Power BI license or Azure Active Directory authentication setup. This option uses Power BI Embedded services to integrate Power BI dashboards or reports into portal.

        Note

        Ensure Power BI Embedded service is enabled and respective Power BI workspaces are selected, and shared with the maker or the logged-in user.

      2. Embed for your organization - Allows you to securely share the Power BI dashboards or reports to Azure Active Directory authenticated users.

        Note

        Ensure you've shared Power BI workspaces with maker and target portal users.

      3. Publish to web - Allows you to share Power BI report or dashboard to anyone on the internet.

      For more information about access types, go to access types.

    2. Workspace: Select the Power BI workspace from the list.

    3. Select type: Select type as Dashboard or Report from the list.

      Select type

      • Dashboard - Allows you to choose a Dashboard, and then a Tile from the selected dashboard to display on the web page.
      • Report - Allows you to select a Report, and then a Page from the report to display on the web page.
    4. Apply roles: If you have defined roles in Power BI and assigned them to reports, you must enter appropriate roles in this field.

      Apply roles

      • You can enter multiple roles separated by a comma (for example, role_1,role_2). For more information on defining roles in Power BI, go to Row-level security (RLS) with Power BI.
      • Only available for access type Embed for your customer.
    5. Apply filter: Allows user to load the report with pre-filtered values. User can provide filter condition in the field.

      Apply filter

      • Filter parameter must be without ?filter='' prefix. For example, Table/Field eq 'value'.
        For more information, go to filter parameter details.
      • Only available for Reports with access types Embed for your customer and Embed for your organization.
    6. Embed code URL: Enter embed code URL.

      Embed Code URL

Power BI access type considerations

The following list explains Power BI access types in brief and lists access type considerations for Power Apps portals. For more information about Power BI access types, go to Difference between Power BI service and Power BI embedded.

  • Embed for your customers:

    • Shows the list of workspaces shared to user currently logged in and enabled for Power BI Embedded service.

    • Uses Power BI Embedded service.

    • If you've used Power BI Embedded service with Power Apps portals before, you'll see the following error when you select Embed for your customers:

      Power BI Embed for your customers - enable visualization again

      When this happens, ensure you disable and then enable Power BI visualization again.

    • If you add Power BI with Embed for your customers on a Power Apps portal page that is available anonymously, anyone can view the dashboard. To secure such a web page, read web page access control in Power Apps portal.

  • Embed for your organization:

    • Shows the list of workspaces shared with logged in user.
    • Uses Azure Active Directory authentication.
  • Publish to web: Anyone on Internet can view your published report or visual. This requires no authentication and includes viewing detail level data your reports aggregate. Before publishing a report, make sure you can share the data and visualizations publicly. Don't publish confidential or sensitive information. Refer to your organization's policies before publishing.

General Power BI considerations

  • Portals Studio performance can degrade while working with Power BI workspaces because of the following Power BI workspace configurations:
    • High number of workspaces shared with logged in maker user.
    • Power BI workspaces are shared with many users.
  • Capture liquid variable isn't supported in portals Studio while working with Power BI component.
  • If you reset portal and provision a new portal, you must add portal application ID of the new portal to the Portal Power BI Embedded service Azure AD security group. For more information, go to Set up Power BI integration.
  • If you make a change in Power Apps portals admin center, you must reload the portals Studio if you already have it open.
  • Adding users to Power BI dashboards and reports may take a while to reflect in the portals Studio.

Power BI performance and optimization considerations

Embedding multiple Power BI workspaces may need additional considerations. Refer to the following resources for Power BI embed scenario troubleshooting, optimization, and best practices:

See also

Set up Power BI integration
Add a Power BI report or dashboard to a web page in portal
Power Apps portals Studio
Create and manage webpages
WYSIWYG editor