How to Publish a Power BI Report to SharePoint

Embedding an active Power BI report directly into a SharePoint page is a straightforward way to share critical data with a wider team. Instead of emailing static files or linking out to the Power BI service, you can bring live, interactive dashboards right into the collaboration hubs your team already uses. This guide will walk you through the different ways to publish and share your Power BI reports within SharePoint Online.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Integrate Power BI with SharePoint?

Connecting Power BI and SharePoint creates a single source of truth for your team's data insights. It transforms your SharePoint site from a simple document repository into a dynamic hub for data-driven decision-making. Here are some of the key benefits:

• Centralized Access: By embedding reports in SharePoint, you eliminate the need for team members to navigate to a separate BI platform. All the business intelligence they need is available right alongside their project documents, lists, and team updates.
• Improved Collaboration: When everyone is looking at the same live data in a shared space, it fosters more informed conversations. You can reference report visuals directly in team meetings or discussions without worrying if someone is looking at an outdated version.
• Enhanced Data Security: SharePoint inherits your existing Microsoft 365 security and permissions structure. When you embed a Power BI report, access is still governed by Power BI's own permission settings, ensuring that only authorized users can view the underlying data.
• Increased Data Adoption: The biggest hurdle to creating a data-driven culture is often friction. If accessing reports is difficult, people won't use them. Placing interactive dashboards directly in a high-traffic environment like SharePoint makes data more visible, accessible, and likely to be used for everyday decisions.

Prerequisites: What You Need First

Before you begin the embedding process, ensure you have the following in place to make the experience as smooth as possible. Jumping in without these permissions checks is a common source of frustration.

• A Power BI Pro or Premium License: Publishing and sharing reports is a feature of Power BI's paid tiers. You’ll need either a Pro or a Premium Per User (PPU) license to share your reports in SharePoint.
• A Published Report: Your report must already be published from Power BI Desktop to the Power BI service (the online version at app.powerbi.com). It can be in "My workspace," but for team collaboration, it's best to publish it to a shared workspace.
• SharePoint Permissions: You must have permission to edit the specific SharePoint Online page where you want to add the report. Typically, this means you need to be a site member or owner.
• Viewer Permissions: Just as importantly, the team members who will view the report on SharePoint need two things: (1) permission to access the SharePoint site, and (2) at least a Power BI Free license and permission to view the specific report or access the workspace it’s in. Embedding doesn't bypass Power BI's built-in security.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Embed Using the Power BI Web Part

The recommended and most secure method for sharing your reports is by using the native Power BI web part in SharePoint Online. It’s designed specifically for this purpose and handles permissions and interactivity flawlessly.

Here’s the step-by-step process:

Step 1: Get the Report Link from the Power BI Service

First, you need the unique URL for the report you want to embed. This link tells SharePoint which specific report to display.

1. Navigate to the Power BI service in your web browser: https://app.powerbi.com.
2. Open the workspace containing the report you want to share, and then click on the report to open it.
3. Once your report is open, go to the top menu and click File > Embed report > SharePoint Online.
4. A pop-up window will appear with a URL in it. This is the special link designed for SharePoint. Click the Copy button to copy the link to your clipboard.

Step 2: Add the Power BI Web Part to Your SharePoint Page

Now, head over to the SharePoint site where you want your report to live.

1. Navigate to the SharePoint page and click the Edit button in the top-right corner to enter edit mode.
2. Hover your mouse over the area where you want to add the report. A line with a circled '+' icon will appear. Click it.
3. A menu with different web parts will pop up. In the search box, type "Power BI" and select it from the results.

You have now successfully added an empty Power BI container to your page.

Step 3: Configure the Web Part Settings

The final step is to tell the web part which report to show and how to display it.

1. With the Power BI web part selected on your page, click the Add report button.
2. A configuration pane will slide out from the right side. In the field labeled Power BI report link, paste the URL you copied from the Power BI service earlier.
3. As soon as you paste the link, the report should automatically load in the main window. Now you can adjust a few settings:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Save and Publish

Once you are happy with the setup, click the Republish (or Publish) button at the top of the SharePoint page. Your changes will be saved, and your interactive Power BI report will now be live and visible to team members with the correct permissions.

Alternative: Using the "Embed" Web Part

You can also use a generic iframe to embed your report using SharePoint’s "Embed" web part. This approach is sometimes used for sharing with a broader audience, including users outside your organization, but it comes with significant security considerations.

This works by using the "Publish to web (public)" feature in Power BI, which creates a publicly accessible link. Be extremely careful with this option: it makes your report and its data accessible to anyone on the internet with the link. Use it only for non-sensitive, public data.

1. In the Power BI service, open your report and go to File > Embed report > Publish to web (public). Power BI will warn you about public access.
2. If you proceed, Power BI will generate HTML code (an <iframe> tag). Copy this entire code snippet.
3. On your SharePoint editing page, add a new web part and search for "Embed".
4. In the Embed part's configuration pane, paste the <iframe> code you copied from Power BI.

Your SharePoint administrator may have disabled the ability to add embed codes for security reasons, so this option may not always be available. The official Power BI web part is almost always the better choice.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Quick Note on Permissions and Security

It's vital to remember that embedding a report on a SharePoint page does not automatically grant people permission to view the Power BI report's data. SharePoint and Power BI permissions work in parallel.

• A user needs access to both the SharePoint page and the Power BI report.
• If a user has SharePoint access but not Power BI access, they will see the web part on the page with an error message asking them to request access.
• This is a feature, not a bug! It protects your data. It ensures that sensitive reports, like executive financial dashboards, are only seen by the intended audience, even if the SharePoint page is visible to the entire company.
• It also fully supports Row-Level Security (RLS). If you've configured RLS in Power BI to ensure a sales manager can only see data for their region, that same rule will apply when they view the report embedded in SharePoint.

Final Thoughts

By bringing interactive Power BI reports directly into SharePoint, you create a seamless experience for your team and bridge the gap between in-depth data analysis and daily collaboration. This integration helps break down data silos and empowers everyone to make more informed decisions right where their work already happens.

Building, managing, and distributing reports across different platforms often highlights the underlying manual effort required just to get answers. We built Graphed to remove this friction entirely. Instead of wrestling with a BI tool for hours, you can connect your scattered data sources (like Google Analytics, Salesforce, or Shopify) in one place and simply ask for the dashboard you need in plain English. Graphed turns the hours of data wrangling into a 30-second conversation, giving you back time to focus on strategy, not configuration.