Others

Display Power BI Reports in SharePoint Server On-Premises

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

An organization wants to display Power BI reports in an on-premises SharePoint Server environment.

How to Display Power BI Reports in SharePoint Server On-Premises
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the report

In the Power BI Report Server web portal, open the report and copy its browser URL.

2
Add the embed parameter

Append ?rs:embed=true to the report URL. If the URL already contains a question mark, append &rs:embed=true instead.

3
Add the report to SharePoint

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.

4
Test viewer access

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.

Embed a Power BI Report Server report in a SharePoint page
Embedding depends on your environment: Available web parts and iframe restrictions vary by SharePoint version and configuration. Adding a report to a page does not grant viewers access to it.
Free Microsoft Office alternative

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.

Prepare documents and spreadsheets to accompany Power BI reportsOpen and edit Microsoft Office formats, including DOCX, XLSX, and PPTXWork in a familiar, easy-to-use interfaceUse a free, lightweight office suite
QA img-9

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.