Display Power BI Reports in SharePoint Server On-Premises
Question details
An organization wants to display Power BI reports in an on-premises SharePoint Server environment.

- Product
- SharePoint Server and Power BI
- Device & OS
- not provided
- Scenario
- Users want to access Power BI reports from a SharePoint site hosted on-premises.
- Observed behavior
- The goal is to show reports within SharePoint while respecting the deployment's authentication and access requirements.
Check your SharePoint Server version and whether the report is hosted in Power BI Report Server or the Power BI service. Confirm that viewers have access to the report and that your SharePoint configuration permits the intended embedding method.
Embed a Power BI Report Server report in a SharePoint page
Use this approach when the report is hosted in Power BI Report Server and your SharePoint page supports an iframe or Page Viewer web part.
In the Power BI Report Server web portal, open the report and copy its browser URL.
Append ?rs:embed=true to the report URL. If the URL already contains a question mark, append &rs:embed=true instead.
Edit a SharePoint page and add a Page Viewer web part or an iframe through an available embed option. Paste the report URL into the web part or iframe, then save the page.
Open the saved page as an intended viewer and confirm that the report loads. If it does not, check Report Server permissions, authentication, and your SharePoint embedding settings.

Use a secure Power BI service embed where supported
Consider this option if the report is hosted in the Power BI service and your on-premises SharePoint page can display the secure embed.
Get guidance for your SharePoint Server deployment
Use specialized support when your server version, authentication setup, or embedding restrictions are unclear.
Create Shareable Office Documents with WPS Office
WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format support make it easy to move existing files, although it does not resolve Power BI embedding in SharePoint Server.

Frequently Asked Questions
Can I use the Power BI web part for SharePoint Online on SharePoint Server?
The SharePoint Online Power BI web part is not an on-premises SharePoint Server integration. For SharePoint Server, evaluate a supported iframe or Page Viewer approach for your report deployment and server configuration.
How do I embed a report from Power BI Report Server?
Open the report in the Report Server web portal, copy its URL, and add rs:embed=true as a URL parameter. Use that URL in a supported SharePoint iframe or Page Viewer web part, then test it with an authorized viewer.
Does embedding a Power BI report give everyone on the SharePoint site access?
No. Viewers still need permission to the report and must meet the applicable authentication and licensing requirements. Check access in Power BI or Power BI Report Server separately.
What should I do if the embedded report does not load?
First open the report URL directly as the affected user. Then check report permissions, sign-in behavior, SharePoint iframe restrictions, and browser settings. Include any error message when asking for help in Microsoft Q&A or the Power BI community.




