How to Embed Power BI Report in SharePoint Online

In this Power Bi tutorial, we will learn how to embed Power bi report in SharePoint Online. There are different ways, we can embed power bi report to SharePoint.

The different ways to embed power bi report in SharePoint:

  • Embed report to SharePoint Online using Embed Link (using Power BI web part)
  • Integrate power bi report to SharePoint online using Power BI report URL (using Power BI web part)
  • Embed power bi report to SharePoint Online using embed code
  • embed power bi report in classic SharePoint page
  • How to fix the error, Contact your admin to enable embed code creation in Power BI
  • How to enable publish to web option in Power bi

How to embed the Power Bi report into SharePoint Online?

In SharePoint Online, we can embed Power Bi report using Embed link, Power BI report web part and using embed code.

Read: Microsoft Power bi report vs dashboard

Embed Power Bi report in SharePoint Online using embed link

Now we will see how to embed the power bi report in SharePoint Online by using the Power Bi web part. Here we are using sample data to create a power bi report by using this sample data.

  • Open your Power bi desktop
  • Load the data using Get data present in the ribbon of power bi.
  • Then go to Report in Power Bi Desktop.
  • Here I have created the visualization using a Stacked column chart, pie chart, card, and Line chart.
finance report page in power bi
finance report page in power bi
  • Click on the publish present in the ribbon in power bi.
publish report in power bi
publish report in power bi
  • After successful publishing, you can open the power bi service directly on the web using app.powerbi.com.
  • Click on My workspace-> Reports present in the navigation in power bi service.
  • Under reports click on the Finance report.
the report in power bi service
report in power bi service
  • Click on the File menu -> click on the Embed Report -> select SharePoint Online.
embed power bi report in sharepoint online
embed power bi report in sharepoint online
  • Copy the Embed Link of the report in power bi.
embed power bi report in sharepoint online
embed power bi report in sharepoint online
  • Open the SharePoint Online site in which site you want to embed the link.
  • On the Home page in SharePoint Online, Click on the New-> Page, to create a new page.
create new page in sharepoint site
create new page in sharepoint site
  • Select a blank page in SharePoint Online. Click on the Create.
  • Give a name to the SharePoint page such as Finance Report. If you are using the existing page to embed the report link, then click on the Edit icon on SharePoint Online Page.
  • Select the Add icon present below section on the SharePoint page.
  • Then search for Power bi web part in SharePoint Online and select it.
power bi web part in sharepoint online
power bi web part in sharepoint online
  • Click on Add Report in SharePoint Online
insert power bi report in sharepoint
insert power bi report in sharepoint
  • Then paste the embed link, under the power bi report link in SharePoint Online.
  • Under the page name, you can select the page.
  • Under the Display section, you can choose the Display size of the report in SharePoint.
power bi report link to another page in SharePoint
power bi report link to another page in SharePoint
  • Click on the publish. in SharePoint Online
  • Now you can see the Power bi report in SharePoint Online.
embed power bi report into sharepoint online
embed power bi report into sharepoint online

Read: Power Bi Schedule Refresh

Integrate Power bi report to SharePoint online

Here we will see how to integrate the report in SharePoint Online by using the Power Bi report URL.

Also we will use the same report i.e. financial report, we have used above( embed power bi report to SharePoint online using embed link)

  • Go to the same report in Power Bi i.e. Financial report.
  • Copy the URL from the address bar.
power bi report url link
power bi report url link
  • You can follow the above topic (embed power bi report to SharePoint online using embed link) to create the page in SharePoint Online or you can use the same financial page which we have created before i.e. Finance Report page in SharePoint.
  • On the Finance report page in SharePoint, click on the add icon present below every section and then select the power bi web part
  • Then click on the Add report.
  • Then under the power bi report link, paste the URL of the power bi report.
paste the power bi report URL  in SharePoint Online
paste the power bi report URL in SharePoint Online
  • Then click on the publish.
  • Now you can see the power bi report in SharePoint Online.
Integrate power bi report in SharePoint Online
Integrate power bi report in SharePoint Online

This is how we can embed a report using Power BI web part in SharePoint Online.

Read: How to Create a Dashboard in Power Bi?

Embed Power bi report to SharePoint Online using Embed Web Part

To display a report by using SharePoint Online embed web part, we need to first get the embed code.

If you got an error like “Contact your admin to enable embed code creation” while getting the embed code, follow the below section.

Let us see, how to embed power bi report code to the SharePoint Online using embed web part. Here we will use the above report i.e Financial report.

  • Open The Financial report in power bi service.
  • Then select the File, from the Dropdown select the Embed Report-> Publish to the web(publicly).
publish to web (public) power bi
publish to web (public) power bi
  • On the Embed code page in Power bi service, Under Link you can send to an email, then you can copy the embed link and you can send it by email.
  • Under HTML you can paste into a website, copy that embed code
  • Next, you can set the size of the report
  • Then under placeholder image, you can set the image, and then you can set the default page.
  • On the right side of the Embed code page, you can see the preview of your report.
  • Once you copy the embed code, you can close the Embed code page
power bi report server embed code
power bi report server embed code
  • Now Go to SharePoint Online where you want to embed the power bi report.
  • Open the page in SharePoint Online
  • Click on the Add icon which is present below the section of the SharePoint Page.
  • Select Embed web parts to add embed code for Power bi report.
Embed web part in SharePoint Online
Embed web part in SharePoint Online
  • Now you can paste the embed code under the Website address or Embed code in SharePoint Online.
  • Click on Republish.
embed power bi report in sharepoint site
embed power bi report in sharepoint site

Now you can see the Power Bi report in SharePoint Online.

embed power bi report server in sharepoint
embed power bi report server in sharepoint

This is how we can embed a Power BI report by using a SharePoint Online embed web part.

Read: 5 Simple and Powerful Power BI dashboard examples

How to enable publish to web option in Power bi

To get the embed code, publish to web option should be enabled in the Office 365, else you will get an error, contact your admin to enable embed code creation.

To fix, this error, let us first understand what is Publish to web in Power BI?

Publish to web is the feature in Power Bi is a free way of sharing Power Bi report with the public.

If the report is published by using publish to web feature, is not secure, and the feature is available to anyone, who has access to the link or embeds code generated through this method.

This feature is controlled by the Power Bi administrator of your tenant and can publish to web or not.

Contact your admin to enable embed code creation

Here we will see how to solve the error message “Contact your admin to enable embed code creation” in the Power Bi service.

So when you select publish to web feature in Power Bi, you will come through this error, if permission to share publicly embed code or embed link is not given to you.

contact your admin to enable embed code creation.
contact your admin to enable embed code creation.

To solve this error, you must have the power bi administrator role or else ask the power bi administrator of your tenant to give permission.

If you have login as admin in Power bi, then

  • Click on the More option in power bi.
  • Then go to Setting-> Admin portal in Power Bi.
admin portal in power bi service
admin portal in power bi service
  • Navigate to tenant setting, under Export and sharing setting.
  • In the publish to web section, enable the publish the web feature.
  • Under how embed code works, choose to Allow existing and new codes.
  • Under Apply to, choose the entire organization
  • Click on Apply.
office 365 contact your admin to enable embed code creation
office 365 contact your admin to enable embed code creation

This is how we can fix, error, contact your admin to enable embed code creation, and how to enable publish to web option in Power bi?

Embed power bi report in classic SharePoint page

Now, let us see, how to embed power bi report in classic sharepoint page.

We can easily embed a power bi report in SharePoint Online site by using a script editor web part.

Open any web part page, then add a script editor web part. Then paste the Power BU embed code there. You can see below the Power BI report is appearing on a classic SharePoint site.

embed power bi report in classic sharepoint page
embed power bi report in classic sharepoint page

In SharePoint classic page, we even can use a content editor web part to display a Power BI report.

You may like the following Power BI articles:

In this tutorial, we learned different ways to embed a Power BI report to SharePoint Online, like by using Power BI web part, and SharePoint Online embed code web part. How to embed a Power BI report in a classic SharePoint page using the script editor web part.

We also discuss how to fix the error, contact your admin to enable embed code creation and how to enable publish to web option in Power bi?

>