Add Power BI

You can add a 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 webpage:

  1. Edit the portal.

  2. Select the page you want to add the component to.

  3. Select an editable element on the canvas.

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

  5. From the 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: From the drop-down, select the appropriate option for your business requirements.

      Power BI Access type.

      1. Embed for your customers - Allows you to securely share the Power BI dashboards or reports to external users without a Power BI license or Azure Active Directory authentication setup. This option uses Power BI Embedded services to integrate Power BI dashboards or reports into your 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 with Azure Active Directory authenticated users.

        Note

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

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

      For more information about access types, go to Power BI access type considerations.

    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 webpage.
      • Report - Allows you to select a Report, and then a Page from the report to display on the webpage.
    4. Apply roles: If you have defined roles in Power BI and assigned them to reports, you must enter the 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.
      • This option is only available for the access type Embed for your customers.
    5. Apply filter: Allows the user to load the report with pre-filtered values. The user can provide a filter condition in the field.

      Apply filter.

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

      Embed Code URL.

      • To learn how to create and manage embed codes, go to Publish to web from Power BI
      • This option is only available for the access type Publish to web.

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 The difference between Power BI service and Power BI Embedded.

  • Embed for your customers:

    • Shows the list of workspaces shared to a 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 message appears, ensure you disable and then enable Power BI visualization again.

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

  • Embed for your organization:

    • Shows the list of workspaces shared with a logged-in user.
    • Uses Azure Active Directory authentication.
  • Publish to web: Anyone on the internet can view your published report or visual. This option requires no authentication and includes viewing detail-level data that 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:
    • A high number of workspaces shared with a logged-in user.
    • Power BI workspaces are shared with many users.
  • The capture Liquid variable isn't supported in portals Studio while working with a Power BI component.
  • If you reset a portal and provision a new portal, you must add the 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 the 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 dashboards and reports connected to a shared dataset present on a different workspace are not supported.
  • Paginated Power BI reports are not supported.

Power BI performance and optimization considerations

Embedding multiple Power BI workspaces may need extra considerations. Refer to the following resources for Power BI Embedded 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