Script is disabled Power BI Reports In SharePoint Online - Portal Integrators

Power BI Reports In SharePoint Online

by

A cloud-based business analytics service by Microsoft, Power BI is a self-service business intelligence tool that provides interactive visualizations, making it easy to create dashboards and reports. You can connect to different data sources which include but not limited to Excel, Azure Analysis Services, Google Analytics, Azure SQL Database, MySQL, and SharePoint Lists.

Power BI reports can now be directly embedded in SharePoint Online modern pages using the Power BI report web part. The steps for doing this are very straightforward.

Power BI is a suite of business analytics tools that deliver insights throughout your organization. – Power BI

Assuming you already have created a report in Power BI, just get the URL.

On Power BI, click File and select Embed in SharePoint Online.

 

 

Go to your SharePoint Online site and select an existing modern or site page, or you can also create a new one. One important thing to note is that you can only use the Power BI web part on modern pages. The WIki and Web Part Pages does not have this Power BI web part.

lick the Add icon and select the Power BI webpart. Copy the link on the dialog. This URL will be needed later when we add the Power BI web part.

In the right panel, just paste in the URL you got from the first step, and then select the Page name from the dropdown. You can set the default display or select one from the dropdown. There are also options to show Navigation andFilter panes. Toggle the selection to show or hide the page navigation or filter panes.

 

 

 

Go to your SharePoint Online site and select an existing modern or site page, or you can also create a new one. One important thing to note is that you can only use the Power BI web part on modern pages. The WIki and Web Part Pages does not have this Power BI web part.

Click the Add icon and select the Power BI web part. Copy the link on the dialog. This URL will be needed later when we add the Power BI web part.

Click Publish to save the changes and publish the page. You should now be able to view the report on your SharePoint Online modern or site page.

 

 

 

Well, that should be the case if the requirements are met. If the report does not show up or is unavailable, then the user probably does not have necessary license to access the report. Since the Power BI web part is rendered on the client, for the report to display properly, the producer and consumer will both need a Power BI Pro license.

Another possible reason why the report is not showing up is because the user has no access to the report. You can either assign the user as a member of the app workspace in your Power BI service or grant users access to the report by sharing the dashboard to them.

Send us your questions on G Suite

14 + 10 =

Related Blog Post