Embedding Power BI Dashboard/Report in Power Apps Portal

Introduction

Power Apps Portals are important in any organization’s long-range web strategy. Portals provide us with a powerful capability to create external-facing websites that allow external and internal users to interact with data from Dynamics 365. In a recent release, Dynamics 365 Portals are now enriched with Power BI Embedded service that allows customizers to grant access to Power BI service components (dashboards, reports, and tiles) to external users who don’t have a Power BI account or license.

This blog post aims to provide a step-by-step guide to embedding Power BI visualizations in Dynamics 365 Portal’s web pages.

Prerequisite

This blog assumes you have an up-and-running Dynamics 365 for Customer Service organization and a Global Admin user with Dynamics 365 and Power BI licenses. You might already have provisioned a Dynamics 365 Portal instance for your organization. If not, go to the Power Apps admin center, select the environment for portal setup, and provision a portal using one of the available templates per your customer requirements, as shown below.

this image shows PREREQUISITE

Steps for Power BI Dashboard and Portal Integration

Once your portal provision is complete and accessible, you will follow the below guide to surface a Power BI report/dashboard on a portal’s webpage.

Enable Power BI Visualization:

To embed the dashboard/report on Portal’s webpage, first, you need to enable Power BI visualization from the Power Apps Portals admin center, and for that: 

  • Open Power Apps and select the environment where you have provisioned the Portal. 
  • Go to Your Apps section from the Power Apps home page and locate your Portal. Select More Commands (…) and click Settings
this image shows ENABLE POWER BI VISUALIZATION
  • In the opened Portal settings pane, select Administration.
this image shows Portal settings pane
  • The Power Apps portals admin center is now opened in a new tab. Please note the Application ID on the  Portal Details page. You will need that in later steps. 
this image shows Power Apps portals admin center
  • From the Power Apps portals admin center, go to Set up Power BI Integration and click Enable Power BI visualization. 
this image shows Power Apps portals admin
  • Click Enable from the confirmation popup. A message will appear once Power BI visualization is enabled. 

Enhance your Decision Making with Power BI!

Explore how Power BI, when embedded in Power Apps portals, can offer real-time insights and analytics with AlphaBOLD. Enhance your strategic planning and data-driven decisions today. Let's explore Power BI's capabilities together.

Request a Demo

Create Azure Ad Security Group and Add to Power BI Account

To display reports or dashboards built-in Power BI workspaces on Portal’s webpage, we need to create a security group in Azure Active Directory, add the Portal application as a member, and add this group to the Power BI account from the admin portal. 

  • Go to Azure Portal and sign in with the Global Admin user for your tenant. 
  • From the left navigation, click on Azure Active Directory. Select Groups from the opened page and click New Group from the top header. 
this image shows AZURE AD SECURITY - Embedding Power BI Dashboard
  • On the New Group page, select Security in Group type and specify a suitable Group name/description. Click Create. 
this shows image Security in Group type - Embedding Power BI Dashboard
  • Open the group you created and click Members under the Manage section. Click on Add members from the top header.
  • Specify the Portal’s Application ID you noted earlier in the Add members search box. Select the item appearing in search results and click Select
this image shows power BI integration - Embedding Power BI Dashboard
  • We need to add this security group to the Power BI service. Go to Power BI and sign in with the Global Admin user.
  • Click on … -> Settings -> Admin Portal from the top right. 
this image shows admin portal - Embedding Power BI Dashboard
  • From the Admin Portal, select Tenant Settings. Locate Developer Settings and expand the Allow service principals to use Power BI APIs section. Enable it from the radio button. 
this image shows power bi Api call
  • Select Specific security groups (Recommended) from the Apply to option and search for your security group by name in the search box. Select the group and click Apply. 
this image shows Specific security groups

Learn more about AlphaBOLD’s BI Services

Create Power BI Workspace and Publish the Report

In this step, we will create a workspace in Power BI and publish a new or existing report/dashboard to this workspace. 

  • Go to the Power BI admin center using Global Admin user and create a new Workspace if it already exists. 
this image shows CREATE POWER BI WORKSPACE
  • Now open the Power BI desktop application, create a new report/dashboard using your data, or open an existing report/dashboard you want to display on Portal. I have created a sample report like this.
this image shows Power BI desktop application
  • Click the Publish command from the toolbar Share section. Select the workspace you created in step one or any of your choice and press Select. A success message is shown when the report is published on the workspace. 
this image shows Publish command from the toolbar
  • Now go back to your Workspace on the Power BI admin center and open the report you just published from the list of available contents. When the report is opened, copy the report URL from the address bar. 
this image shows Workspace on Power BI admin

Enable Power BI Embedded Service from Portal Admin

In this step, we will select the Power BI workspaces to surface reports or dashboards on the Portal’s web pages. 

  • Go back to the Power Apps portal admin center
  • Select Set up Power BI integration from the left pane and click Enable Power BI Embedded service
this image shows Power Apps portal admin center
  • Select the Power BI Workspaces you want to use from the opened window, move to the Selected Workspaces column using the arrow buttons, and click Enable. A confirmation message is shown once the embedded service is successfully enabled. 

Read more: Integrating Power BI: A Guide to Merging with Your Current Infrastructure

this image shows Power BI embed service integration

Transform your Insights with Power BI!

Transform your approach to business intelligence with Power BI and AlphaBOLD. Learn how embedding Power BI dashboards can provide actionable insights and drive your business forward. Let's transform your data insights together.

Request a Demo

Embed Power BI Dashboard/Report to Portal Webpage

The last step is to embed the Power BI report/dashboard into Portal’s webpage using the Power BI liquid tag. 

  • Go to Power Apps, and from the Your Apps section on the Power Apps Home page, click Portal Management
this image shows power bi Portal Management
  • Portal Management app is opened in a new tab. Select Web Pages under the Content section and add a new Web Page. Choose the template, URL, and parent page of your choice and click Save. 
this image shows Portal Management app
  • Open the Content Page from the Localized Content subgrid and go to the Copy (HTML) section. Click on the HTML tab and add the power liquid tag as shown. Please use the authentication type parameter as power bi embedded for reports or dashboards in workspaces. Paste the report URL you noted earlier in the path parameter.
    Power BI tag: {% powerbi authentication_type:”powerbiembedded” path:”Your report URL” %} 
this image shows Power BI report
  • Add this Web Page to the portal Web Link set if needed and browse to the Portal in the new tab. Go to the Power BI web page to see the Power BI report displayed there without needing any authentication or sign-in. 

Read more: Power BI On-the-Go: A Review of the Mobile Experience

This image shows Web Page to portal Web

Conclusion

There you go! You have integrated a Power BI report/dashboard into the Power Apps Portal’s webpage! This blog provides a step-by-step solution for Power BI and Portal integration.

Explore Recent Blog Posts