In this SharePoint online tutorial, we will discuss how to embed Power BI report in SharePoint online by using Power BI Web Part in a modern SharePoint online site.
I will show you how to use SharePoint online power BI Web Part and how to publish Power BI report to SharePoint online classic sites.
Create your Power BI report
if you are new to Power BI, you can follow the below articles and videos to know more about what is Power BI and how to create your Power BI report from a SharePoint list or an Excel file.
I have already created a few power BI reports and we will display those reports in our SharePoint modern site as well as SharePoint classic site.
Publish power BI report to SharePoint Online
There are different ways we can publish Power BI report to SharePoint Online. we can display our reports in a SharePoint online classic site or modern site by using any one of the following approaches:
- using Power BI web Part
- using embedded web Part
- using script editor web part or content editor web part
SharePoint Online Power bi web part
Now, let us see how to use SharePoint Online Power BI web part. In the modern SharePoint Online site, we can use the Power BI web part to display Power BI reports in a SharePoint Online site.
To display reports, we need to first get the Power BI report URL.
Log in to PowerBI.com with your Office 365 credentials.
Then it will display a dialog box, from where, we can copy the Power BI report link.
Then create a SharePoint modern site page in the SharePoint Online site, then edit the page to add the Power BI web part.
Click on the + Add button, then search for Power BI and you can see the Power BI web part.
Then click on Add Report or Edit the Power BI web part. This will open the web part properties panel.
Then enter the Power BI report link, in the Power BI report link box that you have copied from the Power BI site.
Once you add the Power BI report, it will display the Page name, and also you can select Display ratio.
You can also enable the Show Navigation Pane and Show Filter Pane to display the Power BI filter page in the SharePoint web part page.
Once you Save the Page, the Power BI report will appear looks like below in the SharePoint page like below:
This is how we can use the SharePoint Online Power bi web part to display a Power BI report in SharePoint Online.
Embed Power BI reports in SharePoint Online
Now let’s see how to embed Power BI report in modern SharePoint online site. In modern SharePoint Online site, we can use the Embed web part to display the Power BI report in SharePoint Online site.
First, we need to get the embed code for the particular Power BI report. So go the same Power BI like above.
Open the Power BI report, then go to File -> Embed like below:
This will open a dialog box, where you can copy the HTML code and also a link for the embed code. So here copy either one.
Now, open the SharePoint page, edit the page and click on the + icon to add the web part. Search for Embed and you will see the SharePoint online modern embed web part.
Once you add the embed web part, click on Add embed code and you can see it will display the properties where you can either enter the URL or the embed code.
Enter the iframe code or the embed link, both will work fine. Once you add the Power BI code, you can see the Power BI report also.
Note: We can use SharePoint embed web part to display YouTube videos in a SharePoint Online site.
This is how we can display Power BI report or dashboard in SharePoint Online by using Power BI web part or by using SharePoint embed web part.
Publish Power Bi report to SharePoint Online Classic Site
The Power BI web part is not available in classic SharePoint sites, it is available only in modern sites.
But in classic SharePoint site, we can use a script editor web part to display the Power BI report.
Copy the iframe code from the Power BI report.
Edit the SharePoint web part page, and add a web part and select a script editor web part from the Media and Content web part categories like below:
Edit the web part and paste the Power BI report code.
This is how we can display Power BI report in SharePoint Online classic sites.
You may like the following Power BI tutorials:
- Remove blank from Power bi slicer
- Difference between USERNAME() and USERPRINCIPALNAME() in Power BI Dax
- How to create and use Power BI Bookmarks
- What is the difference between calculated column and measure in Power BI
- How to use weekday function power bi with example
- Power BI convert yyyymmdd to date
- Power BI convert hours to minutes
- Get Month Name from Month Number in Power BI
- How to use Power BI sync slicers
- Power BI Calculated Column Example
- Microsoft Lists – Detailed Tutorial
In this tutorial, we learned how to embed Power BI report in SharePoint Online. How to use SharePoint Online modern Power BI web part.
I am Bijay a Microsoft MVP (8 times – My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com