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.

Step – 2:

• Next, click on All apps and then serach the term Microsoft 365 Usage Analytics in the search box. Click on the app.

Step – 3:

• Once you will click on it, the below screen will appear. Hit on the Get it Now button.

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.

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.

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.

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.

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.

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.

• 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.

Step – 10:

• Now come back to the PowerApps Canvas app. Go to the Insert tab -> select Charts -> select Power BI tile as like below.

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 (” “).

• 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.

• When you will click on the OverView section, you will get the reports based on the Year and Month.

• 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.

• 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.

• Similarly, in the Product Usage section, there will be all active sites, All active users, and Total active files that are currently used.

• 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.

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:

• PowerApps Find Function
• Power Apps Azure AD Group
• Power Apps RSS Feed
• PowerApps Weather
• PowerApps Twitter Connector
• Power Apps Calculate + 13 Examples
• Build a Calculator in Power Apps
• Power Apps Rating Control – How to use
• Power Apps Slider Control
• Power Apps Gallery Pagination
• Power Apps Data Table – Complete tutorial
• Migrate PowerApps from one tenant to another
• Power Apps Export Import Control – How to use
• Power Apps PDF Viewer – Complete tutorial
• How to use date time picker in PowerApps
• Power Apps Button Control
• PowerApps Dropdown Gallery + Examples

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