Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Upload Power BI to SharePoint

Cody Schneider••8 min read

Sharing your Power BI reports is the final, crucial step in turning data into decisions. Creating a great dashboard is one thing, but getting it in front of your team where they already work is what sparks real action. This article will show you exactly how to upload and embed your interactive Power BI reports directly into SharePoint Online, creating a single, secure place for your team to access insights.

GraphedGraphed

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.

Watch Graphed demo video

Why Share Power BI Reports on SharePoint?

Before jumping into the "how," let's quickly cover the "why." Integrating Power BI with SharePoint isn't just a technical trick, it's a strategic move that centralizes your team's workflow. Instead of making colleagues hunt for links in emails or messages, you bring the data directly to them.

  • Centralized Access: Your SharePoint site becomes the go-to hub for all project-related materials, including the latest data reports. No more asking, "Hey, can you send me the link to that sales dashboard again?"
  • Enhanced Security: You can leverage SharePoint's familiar and robust permission settings. You control who sees which pages, and by extension, who sees which reports. Access is tied to their existing company login.
  • Seamless Collaboration: With the report living on a SharePoint page, team members can use SharePoint's built-in commenting features to discuss insights, ask questions, and tag colleagues right alongside the visuals.
  • Version Control: Embedding a live report means everyone is always looking at the most up-to-date information. It eliminates the confusion of emailing static copies of .pbix files, which become outdated the moment they're sent.

What You'll Need Before You Start

To ensure a smooth process, make sure you have a few things in place first. Trying to embed a report and running into a permissions wall can be frustrating, so a quick check now will save you headaches later.

  • A Power BI Pro or PPU license: Sharing and embedding a secure report requires a Power BI Pro or Premium Per User (PPU) license. Free Power BI licenses can create reports for personal use but cannot share them in this way. Viewers of the report will also need a Pro or PPU license.
  • A Published Report in a Workspace: Your report must be published from Power BI Desktop to the Power BI Service (app.powerbi.com). Critically, it needs to be in a shared workspace, not your personal "My Workspace."
  • SharePoint Online Page Permissions: You need permission to edit the specific SharePoint page where you want to add the report. If you can't see the "Edit" button in the top-right corner of a SharePoint page, you'll need to ask the site owner for access.

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.

Method 1: Using the 'Embed in SharePoint Online' Feature

This is the best and most common method for securely sharing interactive reports with your internal teams. It uses a dedicated SharePoint web part designed specifically for Power BI, ensuring proper rendering and security.

Step-by-Step Guide:

  1. Open Your Report in Power BI Service: Navigate to app.powerbi.com, go to the correct workspace on the left-hand navigation pane, and click to open the report you wish to share.
  2. Generate the SharePoint Embed Link: Once your report is open, click on File in the top menu bar. From the dropdown menu, select Embed report, and then click on SharePoint Online.
  3. Copy the Link: A pop-up window will appear with a URL. This is not a standard browser link, it's a special link created specifically for integrating with SharePoint. Click the "Copy" button to grab it.
  4. Go to Your SharePoint Page: Open the SharePoint site and navigate to the page where you'd like your report to appear.
  5. Enter Edit Mode: Click the Edit button in the upper-right corner of the SharePoint page. The page content will now become editable.
  6. Add the Power BI Web Part: Hover your mouse over the section where you want to place the report until you see a horizontal line and a circled '+' icon. Click this icon to bring up the list of available web parts.
  7. Select Power BI: In the search box, type "Power BI" and click on the Power BI icon to add it to your page.
  8. Add the Report: A placeholder for the Power BI report will appear on your page. On the right, a settings pane will open. If not, click the pencil icon ('Edit web part') on the web part itself. In the settings pane, click the main Add report button.
  9. Paste Your Embed Link: In the field labeled "Power BI report link," paste the special URL you copied from the Power BI Service in step 3.
  10. Configure Display Options: The web part will automatically load your report. You can customize how it appears on the page. You'll see several options:
  11. Publish Your Page: Once you're happy with the setup, click the Republish (or Publish) button at the top-right of the SharePoint interface. Your report is now live and fully interactive for any team member who has permissions.

Method 2: Uploading the .pbix File Directly (For Backup and Sharing Source Files)

You can also upload the raw Power BI file (.pbix) to a SharePoint document library. It's important to understand the significant limitation of this method: it will not display an interactive report. Instead, it acts as a simple file storage solution.

This method is useful when you want to:

  • Create a central repository or backup of your .pbix source files.
  • Share the source file with other report developers on your team so they can download it and work on it in Power BI Desktop.

How to Upload a .pbix File:

  1. Navigate to the Document Library on your SharePoint site where you'd like to store the file.
  2. Click the Upload button and select Files.
  3. Locate and select the .pbix file on your computer and click Open.

The file will appear in the library just like any other Word document or PDF. When a user clicks on it, they will be prompted to download the file. They cannot view or interact with it directly in the browser.

Managing Permissions and User Access

A common point of confusion is permissions. For a user to successfully see an embedded report in SharePoint, they need permissions in two separate places:

  1. SharePoint Permissions: They need permission to access the SharePoint site and the specific page containing the report. This is usually managed by the site owner using SharePoint groups (Visitors, Members, Owners).
  2. Power BI Permissions: They also need permission to view the report itself within the Power BI Service. If they don't have this, the web part in SharePoint will display an error message like "This content isn't available."
GraphedGraphed

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.

Watch Graphed demo video

Best Practice: Use Microsoft 365 Groups

The simplest way to keep permissions synchronized is to use a Microsoft 365 Group. You can create a group ("Marketing Team," for example) and add all the relevant team members. Then, grant that single group access to:

  • The SharePoint Site.
  • The Power BI Workspace hosting the report (assign them the "Viewer" role).

This way, when a new person joins the team, you only need to add them to one M365 group to give them access to everything they need.

Troubleshooting Common Issues

Even with a perfect setup, you might run into a snag. Here are a few of the most common issues and how to solve them.

Problem: Users see a "This content isn't available" message.

Solution: This is almost always a Power BI permissions issue. The user can see the SharePoint page, but Power BI is blocking them from seeing the report content. Go to the Power BI workspace, click "Manage access," and ensure the affected user has been added (usually as a Viewer) or is part of a group that has access.

Problem: The data in the report seems out of date.

Solution: The report embedded in SharePoint is the same one that lives in the Power BI Service. If the data is stale, it's because the underlying semantic model in Power BI hasn't been refreshed. Set up a scheduled refresh in the Power BI Service for your model to ensure the data is always current.

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.

Problem: The Power BI web part is not available on my SharePoint page.

Solution: In some organizations, administrators can restrict which web parts are available. If you can't find the Power BI web part, contact your SharePoint or M365 administrator. They may need to enable it in the SharePoint admin settings.

Final Thoughts

Embedding your live Power BI reports in SharePoint Online is the best way to integrate business intelligence into your team's daily rhythm. By using the dedicated 'SharePoint Online' embed option, you provide a secure, interactive, and consistently up-to-date source of truth - right inside the collaborative hub your team already uses.

Bringing all your analytics into one place is a powerful way to make smarter decisions faster. If your team spends too much time hopping between platforms and wrestling with reports, our goal is to simplify that process. At Graphed, we connect directly to your marketing and sales sources - like Google Analytics, Salesforce, and Shopify - so you can build real-time, shareable dashboards instantly by asking questions in plain English. There’s no complex setup or embedding required, just clear answers when you need them.

Related Articles