You are currently viewing Integrate Power BI Report in Microsoft Power Portal
Integrate Power BI Report in Microsoft Power Portal

Integrate Power BI Report in Microsoft Power Portal

A short explanation of how to embed your Power BI Report in Power Apps using Portals

Microsoft Power BI is fast becoming the number one go-to tool in terms of business intelligence. It provides users with a business analytics solution that enables you to share insights throughout your organization or integrate them into apps and websites.

Power BI Embedded Analytics allows users to embed Power BI reports, dashboards, and tiles in websites or other applications. The embedded capability feature of Microsoft Power BI is determined by the user or organization licenses.

Requirement

To follow along with this article, you should have a basic understanding of Power BI Desktop, Power BI Service, Azure Portal, and how to create a workspace in Power BI services.

You should also have an Office 365 license, and get the Microsoft Developer account free account.

What are Microsoft Power Apps

Power Apps is a collection of apps, services, connectors, and a data platform that offers a quick development environment for creating unique apps for your company’s requirements. You can easily create unique business apps with Power Apps that connect to your data housed in the Microsoft Dataverse underpinning data platform or in a variety of online and on-premises data sources (such as SharePoint, Microsoft 365, Dynamics 365, SQL Server, and so on).

 

Power Apps Portal

Power Apps Portal provides users with the ability to create websites for both internal and external users with the help of data stored in the Microsoft Dataverse. If this is your first time using the Power Apps, you will need to create a Power App Portal.

Step 1

Go to the Power Apps site, in the Home tab, click on Blank App then select Power Pages website.

Step 2

If the selected environment does not contain portal pre-requisite, the message below would pop up saying you should select another environment or create a new one.

Step 3

Fill in all necessary information then click create.

Step 4

After you click on the create button, this may take a couple of minutes to create but as soon as the portal is created, you will get a notification that your portal is ready for use.
Head to the “Apps” tab where you will see the Portal you just created.

Configure Power BI in Power Apps

Step 1: Enable Power BI Visualization

We need to enable Power BI visuals in the App portal just created.

From the setting, click on the “Administration Tab”, this should open another window for you.

In the new tab, scroll down to “Set up Power BI integration” and click on “Enable Power BI Visualization

A pop-up message will appear “This action will enable Power BI visualization through the Liquid tag. Portal will be restarted and it will be unavailable for a few minutes.” Click on Enable, to start the integration process.

Manage Power BI Embedded Service

You can integrate dashboards and reports developed in Power BI workspaces by enabling the Power BI Embedded service.

Note: Ensure you have your report and dashboard already created in your workspace before enabling this feature. Give the global administrator admin access after creating the workspace so that it appears in the Power Apps portals admin center.

Access Integration Directory

We need to enable access to the integration in the Azure Portal. You need to create a security group in Azure Active Directory, add members to it, then utilize the Power BI admin portal to add the security group in Power BI.
The dashboards and reports produced in Power BI workspaces can now be viewed in the portal with this configuration.

Step 1:

From your Azure Portal homepage click on the View in “Manage Azure Active Directory

Step 2:

In the Azure Active directory, click on “Group” in the left corner of the tab, then create a “New group”.

Step 3:

Make sure the Group type is set to security, add your group name and description, then create.

 

Next, click on the group you just created and go to the member

Step 4:

To “Add Member” you need to copy the “Application ID” from the Power Apps.
In your Power Apps Click on the Setting and select “Administration”. This would open Power Apps portals admin center. 

Step 5:

Go back to the Azure Directory member, which is in “step 3” above, and click on add members.

In the Search area “Paste” the Application ID gotten from step 4, then click the select button to add the new member.

Click on the member created to check if all properties are made available.

Power BI Admin Portal 

Next, you need to go to Power BI Services and enable all necessary settings.

Step 1:

From the Power BI Service homepage, at the top right corner, click on the 3 dots then “Settings” > “Admin portal”.

Step 2:

In the Admin portal, click on Tenant Settings, then go to the Developer Settings. At the Developer setting expand “Allow service principal to use Power BI APIs”, and Enable it. Type in the security group name we created in our Azure Portal. Click on apply when you’re done adding the security portal.

Step 3: 

Next, under the Developer Setting go to “Embed Content in Apps” Enable it. This is done to help the report and dashboard display properly.

Power Portal Apps

Step 1:

Next, go to Power Apps and in the Portal, you just created, click on the 3 dots and select the “Edit button”. This would take you to the make Power App tab.

Step 2:

In the Power App, portal environment clicks on the component button, which is at the top left corner, then select Power BI. This would help in creating a liquid tag in your Power Apps.

Step 3:

Access type selection which are in 3 forms:

  • Embed for your customer.
  • Embed for your organization.
  • Publish to web.

Step 4:

Lastly, we need to set the Power Apps so we can preview our dashboard. When you are done click on “Browse Website”.

Final Outcome

Click on “Browse Website”, this would give the final outcome of our dashboard.

Final Thought

In this blog, we learned how to configure Power Portal to embed Power BI reports and dashboards into Power Apps. The Power Apps portal provides you a Low-code No-code of the way in Embedding Power BI report.

To learn more about Power BI, you should sign up for our classes, keep up with the blog, and subscribe to our YouTube channel.

 

Reference:

 

Leave a Reply