Display Power BI Report in SharePoint Online

InfoPath alternatives for form designing SharePoint

Power BI is great tool for data visualization. Many organization using the tool for reporting purpose.

Now showing Power BI reports in SharePoint online has its own trick.

There are many ways to display Power BI reports to SharePoint Online.

I will be sharing two major approaches and each approach pros and cons.

Also read: Copy blobs from one storage container to another storage Container in Microsoft Azure

Below two approaches can be used based on your project security requirement.
1. Publish the Power BI Report and Display in Iframe

2. Provider Hosted App to display the report

Publish the Power BI Report and Display in Iframe-

All reports need to be placed in Power BI online and then follow below steps to display the report in SharePoint Online.

1. Publish the Report to internet. When we publish Power BI report, automatically it will be published to internet.

2. Get the Report URL once it’s published.

3. Add content editor webpart to SP page where you want to display the report.

4. Display the report in iframe.

<iframe width=”1100″ height=”600″ src=”https://app.powerbi.com/view?r=**************************************************************************************” frameborder=”0″ allowFullScreen=”true”></iframe>

Cons of the Approach-
1. Report will be displayed in SP Online without any additional authentication for Power BI.

2. View Page source can be used to find the report URL. It may be a security issue as report URL will be published to internet and accessible anonymously.

Considering the security issue, I will be talking about the provider hosted app approach in next post.

Similar SharePoint 2013 Tutorials

About Sambita Rath

I have 9 years of exprience into SharePoint implementation, architecture, Administrator, development and Training.Designing Information Architecture in SharePoint 2007, 2010,2013 and Office 365.

View all posts by Sambita Rath →

Leave a Reply