In this PowerApps tutorial, we will discuss how to embed Power bi report in PowerApps portal. Basically, we will see how to embed Power BI Microsoft 365 Usage Analytics report in PowerApps.
We will see here how in a very few steps embed power bi report in powerapps or how to show the power bi report in PowerApps.
As we know Power BI has a great role which will provide interactive visualizations and business intelligence capabilities to prepare a report. And Power BI is a part of office 365 subscription where we can easily communicate from another source.
Embed power bi report in PowerApps portal
Now, we will see how to embed power bi report in powerapps portal.
But first, we will see how to create the report in Power BI.
Step 1: Log in to Office 365 (Power BI) -> Go to the Power BI section. Next, go to the Apps and search Microsoft 365 Usage Analytics.
It will take some time to install this app in your application so wait for some time.
Now Microsoft 365 Usage Analytics report is ready to use. But here we need SharePoint Tenant ID to connect to our Data Source.
Step 2: We have to provide the Tenant ID for authentication. You can get a Tenant ID from Azure Active Directory. Next click on OK.
Step 3: Next our report is now ready. We can use this report in PowerApps. So here we have an option called Embed. So click on the Website or Portal. Next copy the URL and which we can use in PowerApps.
Step 4: Next go to the PowerApps -> Next go to the Charts and drag and drop Power BI tile.
And set the TileUrl with URL which you copied from Power BI. Next, save the page and click on deploy.
Step 5: If you click on Executive Summary, you will get details of all usage reports, Storage, Communication, Collaboration, Adoption, Exchange, OneDrive, SharePoint, Team, Yammer, and Skype for Business.
Step 6: In the OverView section, you will get reports based on the Year and Month.
Step 7: In the Activation/Licensing Section, You will get total active users in a graphical way. And users which created newly, all report we can get it from here.
Step 8: In Licenses Assigned section, you will get all subscription name which is activated for you and how many licenses assigned to you.
Step 9: In Product Usage, you will get all active sites, All active users, and Total active files that are currently used.
Step 10: In User Activity, you will get all product activity based on location. Here we can easily track from which country mostly use our product and how many users are used.
You may like the following PowerApps tutorials:
- Display Office 365 User Profile Properties in PowerApps
- Create a portal in PowerApps
- PowerApps twitter connector example
- How to show RSS feed in PowerApps
- PowerApps Examples: Restaurant management system
- How to create calculator in PowerApps
- How to display Power bi google analytics in PowerApps
- PowerApps nested gallery control example
In this tutorial, we learned how to embed power bi report in PowerApps portal.
Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).