Embedding a Power BI report in SharePoint Online means putting it directly into a SharePoint page. This allows any member of your organization to access the Power BI report on the SharePoint site.
In this tutorial, we will learn how to embed Power BI reports in SharePoint online and add them to the SharePoint site.
Publish Power BI Report to SharePoint Online
There are various methods for publishing a Power BI report to SharePoint Online. We can showcase our reports on a SharePoint online site by utilizing Power BI web Parts and embedded web Parts.
Power BI Publish to SharePoint Power BI Web Part
In this example, we will see how to publish a Power BI report on the SharePoint Online site.
To showcase reports, you need a report created in Power BI Service.
Note:
If you don’t know how to create a report in Power BI, you can refer to our Power BI Tutorial for guidance.
Now follow the below steps:
1. Go to the Power BI Service and open the report that you want to show on the SharePoint site.
2. Expand the File tab and select Embed report, then click SharePoint online.
3. Then, it will display a dialog box from where we can copy the Power BI report link.
4. Go to the SharePoint Online site, then edit the page and add the Power BI web part.
5. Next, click “Add report“. This action will open the web part properties panel. In the “Power BI report link” box, paste the link copied from the Power BI service.
6. Once you save the page, the Power BI report will appear on the SharePoint page as shown below:
Following these steps, you can publish a Power BI report on the SharePoint Online site using the Power BI web part.
Embed Power BI report in SharePoint
In this example, we will see how to publish a Power BI report on the SharePoint Online site using an embed web part.
1. Go to the Power BI Service and open the report that you want to show on the SharePoint site. Expand the File tab and select Embed report, then click Website or total.
2. Then, simply copy any of the links provided in the dialog box below.
3. Go to the SharePoint Online site, then edit the page and add the embed web part into the page.
4. You’ll notice that it displays the properties where you can enter either the URL or the embed code.
5. Then, you’ll be able to view the Power BI Report on the SharePoint site page.
This way, you can Publish Power BI reports on the SharePoint site using embedded web parts.
In this tutorial, we’ve covered how to publish a Power BI report on a SharePoint Online site using Power BI web parts and how to do the same using the embed web part.
You may also like the following tutorials:
- How to Filter Between Two Dates in Power BI
- Create Power BI Bookmarks
- Stacked Bar Chart in Power BI
- How to Add Conditional Column in Power BI
- Power BI Change Color Based On Value
I am Bijay a Microsoft MVP (10 times – My MVP Profile) in SharePoint and have more than 17 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