Integration with Power BI

Completed

You can add a Power BI report or dashboard to a webpage in a Power Apps portal to further extend the portal as a powerful web application.

Before you can add a Power BI report to a Power Apps portal, you will need to enable the Power BI visualization or the Power BI Embedded service in the Power Apps portals admin center.

Screenshot of the admin center Set up Power BI integration with Enable Power BI visualization and Enable Power BI Embedded service features.

  • Power BI visualization - Allows you to embed publish to web Power BI reports for anonymous visitors or share Power BI reports or dashboards to Power BI Azure Active Directory authenticated users (for example, on an Employee self-service portal).
  • Power BI Embedded service - Allows you to share the Power BI reports or dashboards to external users who don't have a Power BI license or Azure Active Directory authentication set up. This feature uses the new workspaces feature of Power BI. For more information, see Create the new workspaces in Power BI).

Enable Power BI visualization

Enabling Power BI visualization allows a portal maker to add a Power BI component to a portal page and configure it to display a Power BI report or dashboard that is available for being published on the web. A report author will need to generate an embed code in Power BI Dashboard.

From the Power Apps portals Studio, you can add the Power BI component to a portal page. This action will add a Liquid tag to the portal page, which can be further configured in the portals Studio source code editor, depending on the specific requirement.

Screenshot of the Portal components with Power BI highlighted.

Parameters

The powerbi Liquid tag accepts the following parameters:

  • path - Path of the Power BI report or dashboard. If the Power BI report or dashboard is secure, you must provide the authentication type.

    {% powerbi path:"https://app.powerbi.com/groups/00000000-0000-0000-0000-000000000000/reports/00000000-0000-0000-0000-000000000001/ReportSection01" %}
    
  • authentication_type - Type of authentication that is required for the Power BI report or dashboard. Valid values for this parameter for embedded Power BI visualizations are Anonymous and Azure AD. The default value is Anonymous. While adding the Power BI report or dashboard, ensure that it is shared with Microsoft Dataverse Azure AD authenticated users.

    % powerbi authentication_type:"AAD" path:"https://app.powerbi.com/groups/00000000-0000-0000-0000-000000000000/reports/00000000-0000-0000-0000-000000000001/ReportSection01" %}
    

You can also filter the report on one or more values. For more information, see Filter a report by using query string parameters in the URL.

Important

The Anonymous report doesn't support filtering.

Filtering can be based on dynamic values, making it a great option to display personalized Power BI visualizations. You can also create a dynamic path by using the capture Liquid variable, as shown in the following example:

{% capture pbi_path %}https://app.powerbi.com/groups/00000000-0000-0000-0000-000000000000/reports/00000000-0000-0000-0000-000000000001/ReportSection01?filter=Executives/Executive eq '{{user.id}}'{% endcapture %}
{% powerbi authentication_type:"AAD" path:pbi_path %}
  • tileid - Displays the specified tile of the dashboard. You must provide the ID of the tile.

    {% powerbi authentication_type:"AAD" path:"https://app.powerbi.com/groups/00000000-0000-0000-0000-000000000000/dashboards/00000000-0000-0000-0000-000000000001"     tileid:"00000000-0000-0000-0000-000000000002" %}
    

Before adding the Power BI report or dashboard to a webpage in a portal, you must share it with the required users.

Screenshot example of Power BI chart on a portal page.

Enable Power BI Embedded service

You can also enable and configure the Power BI Embedded service within the Power Apps portals admin center.

When you enable the Power BI Embedded service, make sure that you specify the Power BI workspaces that will be available for use on the portal.

Screenshot of the Enable Power BI Embedded service integration window.

When the Power BI Embedded service is activated, makers will be able to embed Power BI reports on a portal page, which will take advantage of the features and functionality of the Power BI Embedded service without makers needing to write corresponding code on the portal. You will need to have created a workspace within Power BI and added the appropriate reports, dashboards, and tiles.

When you are adding an embedded Power BI report, specify if the audience is for your customers (external users) or for your internal employees. Employees will need to authenticate to the portal by using Azure AD. When you are adding a report for external users, set the value of authentication_type to powerbiembedded, as shown in the following example:

{% powerbi authentication_type:"powerbiembedded" path:"https://app.powerbi.com/groups/00000000-0000-0000-0000-000000000000/reports/00000000-0000-0000-0000-000000000001/ReportSection01" %}

Screenshot of an organization embedded Power BI report.

Note

Power BI sharing requires appropriate licensing to be in place. Licensing requirements depend on the audience and method of sharing.

For more information on setting up Power BI integration, see Set up Power BI integration.

For more information on sharing and licensing requirements, see Share Power BI workspace and Share Power BI dashboard and report.