Embed Power BI report in SharePoint Online (Power BI Web Part)

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:

  1. using Power BI web Part
  2. using embedded web Part
  3. 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.

Embed Power BI report in SharePoint Online
Power BI report URL

Then it will display a dialog box, from where, we can copy the Power BI report link.

sharepoint online power bi web part
Power BI report link url

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.

Power Bi web part
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.

sharepoint online modern power bi web part
sharepoint online modern power bi web part

Once you Save the Page, the Power BI report will appear looks like below in the SharePoint page like below:

embed power bi in sharepoint
embed power bi in sharepoint

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:

sharepoint online modern power bi web part
sharepoint online modern power bi web part

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.

publish power bi report to sharepoint online
publish power bi report to sharepoint online

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.

publish power bi report to sharepoint
publish power bi report to sharepoint

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.

how to publish power bi report to sharepoint online
publish power bi report to sharepoint online using embed web part

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.

how to publish power bi report to sharepoint
how to publish power bi report to sharepoint using embed web part

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.

publish power bi report to sharepoint online

This is how we can display Power BI report in SharePoint Online classic sites.

You may like the following Power BI tutorials:

In this tutorial, we learned how to embed Power BI report in SharePoint Online. How to use SharePoint Online modern Power BI web part.

>