How to Publish Power BI to SharePoint

Embedding your Power BI reports directly into SharePoint Online is a fantastic way to centralize your team's analytics and provide data in the context of their daily work. This article will walk you through, step-by-step, how to publish a Power BI report to a SharePoint page. We'll cover the best method using the dedicated Power BI web part and other best practices to ensure your team gets the most out of your data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Embed Power BI Reports in SharePoint?

Placing your Power BI reports inside SharePoint isn't just about convenience, it fundamentally changes how your team interacts with data. Instead of sending links to dashboards that get lost in emails or chats, you create a central hub where data lives alongside project documents, team updates, and other relevant content.

Here are the key benefits:

• Centralized Access: Your SharePoint site becomes the single source of truth. Team members know exactly where to go to find the latest sales numbers, marketing performance, or project metrics without hunting for a bookmark.
• Data in Context: You can place a marketing campaign performance report on the marketing team's SharePoint page or embed a project budget tracker directly on the project's homepage. This puts data right where decisions are made.
• Seamless User Experience: Team members can view and interact with reports without ever leaving the SharePoint environment they use every day. This reduces friction and encourages more frequent engagement with the data.
• Secure and Controlled Sharing: You can leverage SharePoint's familiar permissions model alongside Power BI's security settings to ensure that only the right people see sensitive information.

Prerequisites: What You’ll Need

Before you begin, ensure you have a few things squared away. This will make the process much smoother.

• A Power BI Pro or Premium Per User (PPU) license. Sharing and embedding reports requires a professional license. Free users can create reports for themselves, but they can't share them this way.
• A report published to the Power BI service. You must first create your report in Power BI Desktop and then publish it to a workspace in app.powerbi.com.
• Access to SharePoint Online. This method is designed for SharePoint Online (part of Microsoft 365) and will not work with on-premise SharePoint Server versions.
• Permissions to edit the SharePoint page. You'll need to be a site owner or have member/edit permissions for the specific SharePoint site and page where you want to add the report.

Important Note on Permissions: For others to view the embedded report, they need permission in TWO places: access to the SharePoint page itself AND access to the underlying Power BI report. We'll cover this more in the best practices section.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Publish Power BI to SharePoint: The Power BI Web Part Method

The easiest and most modern way to embed your report is by using the official Power BI web part for SharePoint Online. It's designed specifically for this purpose and works flawlessly.

Step 1: Get the Report Link from Power BI

First, you need to grab the correct sharing link from the Power BI service.

1. Navigate to app.powerbi.com and sign in.
2. Open the workspace and the specific report you want to embed.
3. In the top menu bar, click on File > Embed report > SharePoint Online.
4. A dialog box will appear with an embed link specifically for use in SharePoint. Click the Copy button to copy this URL to your clipboard.

This link is unique because it's designed to work with SharePoint's authentication, maintaining the security rules you've set up in Power BI.

Step 2: Go to Your SharePoint Page and Enter Edit Mode

Now, head over to the SharePoint site where you want your report to live. Navigate to the exact page and click the Edit button in the top-right corner. This will put the page into edit mode, allowing you to add and modify content.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Add the Power BI Web Part

Find a spot on the page where you'd like the report to appear. Hover your mouse there until a horizontal line with a "+" icon appears. Click this icon to open the web part gallery.

In the search box, type "Power BI" and select the Power BI web part from the list.

Step 4: Configure the Web Part

Once you add the web part, it will look like an empty box. Click the Add report button at the center of it.

A configuration pane will slide out from the right side of the screen. In the section labeled Power BI report link, paste the special URL you copied from the Power BI service in Step 1.

As soon as you paste the link, the report should automatically load in the main content area, giving you a live preview.

Step 5: Customize the Display Options

The configuration pane offers several useful options to control how your report appears on the page. You're in control of the user's initial view:

• Page name: If your report has multiple pages, you can choose which one displays by default. This is perfect for creating dedicated sections in SharePoint for different views of your data. Simply type the name of the page as it appears in the report.
• Display: You can choose how the report fits into the space. "16:9" preserves the report's aspect ratio, while "Fit to page" makes it responsive to the SharePoint section it's in.
• Show Nav Pane: This toggle lets you show or hide the page navigation from the bottom of the Power BI report. If you only want users to see a single report page, turn this off.
• Show Filter Pane: Similarly, you can show or hide the Power BI Filters pane. For high-level executive dashboards, you might hide this to simplify the view. For analytical views, you'll want to keep it on.

Step 6: Publish Your SharePoint Page

Once you're happy with how the report looks and is configured, click the Republish or Publish button at the top-right of your SharePoint page. This saves your changes and makes the live, interactive report visible to anyone who has the proper permissions.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices for Success

Embedding the report is half the battle. Presenting it effectively is the other half. Here are a few tips to ensure your team gets the most value from your embedded reports.

• Get Permissions Right: This is the most common pitfall. If your user sees an error like "This content isn't available," it's almost always a permissions issue. They must have been granted access to view the report in the Power BI service in addition to being able to see the SharePoint page. The easiest way to manage this is by using Microsoft 365 Groups. Create a group, give it access to both the SharePoint site and the Power BI workspace, and add your team members to that single group.
• Add Context Around the Report: Don’t just drop a complex report onto an empty page. Use SharePoint’s Text web part to add a title, a brief paragraph explaining what the data shows, who owns the report, and when it was last updated. Give your team the context they need to understand what they're looking at.
• Link to a Specific Page: Avoid embedding a massive, 15-page report and making users figure out where to go. If the SharePoint page is about sales performance in the US, use the "Page name" setting in the web part to make the report default to the "US Sales" page.
• Optimize Your Report for Performance: A slow-loading report won't get used. Before publishing, make sure your report is optimized within Power BI Desktop. This includes things like having an efficient data model, reducing visual clutter, and using efficient DAX measures. A snappy report in SharePoint makes for a great user experience.

Final Thoughts

Publishing your Power BI reports directly to SharePoint is a powerful way to make data a seamless part of your organization’s workflow. By using the dedicated web part and following a few best practices for permissions and context, you can create a dynamic and centralized data hub that empowers your team to make smarter, more informed decisions.

While tools like Power BI are incredibly powerful, we know that getting to a finished dashboard can involve a steep learning curve and hours of manual report building. We built Graphed to remove that friction. By connecting all your marketing and sales data sources, you can use simple, natural language - like asking a question - to instantly generate live dashboards. It's like having a data analyst on your team who can turn your questions into a finished report in seconds, not hours.