Power BI integration with PowerApps Portals

Do you ever think that you can view your Power BI Reports or Dashboard in a PowerApps Portal? Yes, it is possible to achieve.

In this PowerApps Tutorial, We will discuss how to integrate or embed a Power BI Report in the PowerApps portal. Follow the below steps to work around with.

Embed Power BI in Power Apps Portal

  • Now we will see how we can embed the Power BI Microsoft 365 Usage Analytics report in the Power Apps portal.
  • Before that, We need to make a report in Power BI. Check out this link that how you can create a Power BI Report.
  • Next, follow these below steps that how you can embed the Power BI report in PowerApps Portal.

Step – 1:

  • At first, Login to the Office 365 -> Power BI -> Click on Apps -> Search Microsoft 365 Usage Analytics in the search box.
  • If you are searching it for first time, then you will not get it in the app. You need to install this app in your application.
  • To install the app, click on the Get apps button on the top right corner as shown in the below screenshot.
Embed Power BI in PowerApps Portal

Step – 2:

  • Next, click on All apps and then serach the term Microsoft 365 Usage Analytics in the search box. Click on the app.
Power BI integration with PowerApps Portals
Power BI integration with PowerApps Portals

Step – 3:

  • Once you will click on it, the below screen will appear. Hit on the Get it Now button.
Power BI integration with PowerApps Portal

Step – 4:

  • After a while, it will ask you to provide the basic profile information like Name, Work email, Job title, etc. After that. you need to check in the agreement and then click on Continue.
  • To install the app, Press the Install button. Once you will press it, it will take some time to install properly.
Power BI integration with Power Apps Portals
Power BI integration with Power Apps Portals

Step – 5:

  • Now as you can see, the Microsoft 365 Usage Analytics app is ready to use. Just you need to click on the app.
Power BI integration with Power Apps Portal

Step – 6:

  • When you will click on the app (Microsoft 365 Usage Analytics), it will ask you to provide the SharePoint TenantID. Then you must be think that where you can get the tenant id to connect to our database. This is for Authentication purpose. Follow the next step to get your SharePoint Tenant ID.
Power BI embed with PowerApps Portal

Step – 7:

  • You can get your Tenant ID from the Azure Active Directory. Login to Azure portal -> go to Properties from the left navigation -> Copy the ID under the Tenant ID section that I have highlighted in the below screenshot.
  • Then, go to the Microsoft 365 Usage Analytics page, Paste the Tenant ID that you have copied recently and then click on the Next button.
Power BI embed with Power Apps Portal

Step – 8:

  • After that you need to select an Authentication method i.e. OAuth2 and then press the Sign in and connect button as shown below.
Embed Power BI in Power Apps Portal

Step – 9:

  • Now our Power BI Report is ready to use in the Power Apps portal. In the Power BI app, go to Apps -> File (top of the bar) -> Select Embed report -> Choose Website or portal as shown below.
Power BI integration in Power Apps Portals
  • When you will click on the Website or portal, the report link will display on the page where you can use it to embed. Copy the link and paste it in a notepad.
Power BI integration in Power Apps Portal
Power BI integration in Power Apps Portal

Step – 10:

  • Now come back to the PowerApps Canvas app. Go to the Insert tab -> select Charts -> select Power BI tile as like below.
How to embed Power bi report in PowerApps portal

Step – 11:

  • Next, Paste the copied Power BI report embed URL on the TileUrl property of the Tile chart as shown in the below screenshot.
TileUrl = "https://app.powerbi.com/reportEmbed?reportId=78097b49-1a62-4702-acd1-e2541df44909&appId=2c48208a-be55-4070-a218-ce8632d2613f&autoAuth=true&ctid=f0e4273f-10c1-4551-a494-977ebeb5b5fa&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLWluZGlhLWNlbnRyYWwtYS1wcmltYXJ5LXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9"

You must ensure that the Embed URL should be present within the inverted comma (” “).

Embed Power bi report in PowerApps portal
  • Once you will apply the link in the app, then the Microsoft 365 Usage Analytics report will display in the PowerApps chart as shown in the below figure.
  • When you will click on the Executive Summary from the left navigation, then you will get all the information of Adoption, all usage reports, Mobility, Communication, Collaboration, Storage, Exchange, OneDrive, SharePoint, Teams, Yammer, and Skype for Business.
power bi integration powerapps
Power bi integration PowerApps
  • When you will click on the OverView section, you will get the reports based on the Year and Month.
Power bi integration Power Apps
  • When you will click on the Activation/Licensing section, there will be total active users in a graphical way. Also, you can get all reports that has been created by the new users.
Power bi integration in PowerApps
  • In the Licenses Assigned section, there will be al subscription names that is activated for you and also the information that how many licenses assigned to you.
Power bi report integration in PowerApps
  • Similarly, in the Product Usage section, there will be all active sites, All active users, and Total active files that are currently used.
Power bi report in PowerApps
Power bi report in PowerApps
  • In the User Activity section, it will show all the product activities based on their location. Here we can easily track from which country mostly use our product and how many users are used.
embed Power bi report in PowerApps
embed Power bi report in PowerApps

This is how we can embed the Power BI Microsoft 365 Usage Analytics report in the PowerApps portal.

Also, you may like the below PowerApps tutorials:

In this PowerApps Tutorial, We discussed how we can integrate or embed a Power BI Report in PowerApps portal.

>