Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Upload Power BI Report to SharePoint

Cody Schneider••8 min read

You’ve meticulously crafted the perfect Power BI report, complete with insightful visualizations and crucial KPIs. The next step is getting it in front of your team where they actually work, and for many organizations, that means SharePoint. This article will guide you through the best methods for uploading and embedding your Power BI reports directly into SharePoint, transforming your site into a dynamic, data-driven hub.

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 in SharePoint?

Integrating Power BI with SharePoint is a game-changer for team collaboration and data accessibility. Instead of forcing team members to navigate to the Power BI service every time they need an update, you bring the data to them.

  • Centralized Information: Your report lives alongside other project documents, wikis, and team communications in one central, easy-to-find location.
  • Live, Interactive Data: Embedded reports aren't static images. They are fully interactive and refresh automatically, ensuring your team is always looking at the most current data.
  • Contextual Insights: You can place a marketing report on the marketing team’s SharePoint page or a sales dashboard on the sales site, providing data in the context of their daily workflow.

Before You Start: Key Prerequisites

Before you jump in, let's make sure you have everything you need. A little preparation will ensure the process is smooth and error-free.

  • Power BI Pro or Premium Per User (PPU) License: This is non-negotiable for sharing. Both the person publishing the report and the people viewing it in SharePoint need a Pro or PPU license. This is a common sticking point, so confirm your and your viewers' licensing first.
  • A Published Power BI Report: Your report can't be a local file on your computer. It must be published from Power BI Desktop to a workspace in the Power BI service (app.powerbi.com). Avoid publishing to "My Workspace" for team content, use a dedicated group workspace instead.
  • Clearance from your Power BI Admin: Your organization's Power BI administrator must have the "Embed content in apps" setting enabled. If you run into issues, this is one of the first things to check.
  • SharePoint Online Editor Permissions: You'll need permission to edit the SharePoint page where you want to embed the report.

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: Embedding Your Report with the Power BI Web Part (Recommended)

The Power BI web part for SharePoint Online is the most direct, secure, and feature-rich way to display your reports. It creates a seamless experience where your Power BI report feels like a native part of the page.

Step 1: Publish Your Report to the Power BI Service

If your report is still a .pbix file on your hard drive, your first task is to get it into the cloud.

  1. Open your report in Power BI Desktop.
  2. In the "Home" ribbon, click the Publish button.
  3. You'll be prompted to select a destination workspace. Choose a relevant team workspace (e.g., "Marketing Analytics," not "My Workspace").
  4. Click Select. After a few moments, you'll get a success message with a link to open the report in the Power BI service.

Step 2: Get the Report Link

Once your report is in the Power BI service, you need to grab its unique URL.

  1. Navigate to the report in your Power BI service workspace.
  2. Open the report you want to embed.
  3. Simply copy the URL from your browser's address bar. It will look something like this: app.powerbi.com/groups/[GroupID]/reports/[ReportID]

There's no specific "SharePoint" embed code you need to generate for this method, a direct link is all you need for the web part.

Step 3: Add and Configure the Power BI Web Part in SharePoint

Now, head over to your SharePoint site to place the report on your desired page.

  1. Navigate to the SharePoint page you want to edit and click the Edit button in the top-right corner.
  2. Hover your mouse over the area where you want to add the report, and a line with a circled '+' will appear. Click it to add a new web part.
  3. In the web part search box, type "Power BI" and select it from the list.
  4. A Power BI web part pane will appear on the page. Click the Add report button.
  5. In the panel on the right, paste the Power BI report URL you copied in the previous step into the "Power BI report link" field.
  6. The report should automatically load in the web part. You can then configure its appearance using the options in the panel:
  7. Once you're happy with the settings, click Republish or Publish at the top right of your SharePoint page to save your changes.

Your team can now view and interact with the live report directly within SharePoint!

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

Method 2: Uploading a .PBIX File to a Document Library

You can also upload your static Power BI Desktop file (.pbix) directly to a SharePoint document library, much like you would a Word or Excel file. When a user clicks on it, SharePoint opens the report in a viewer connected to the Power BI service (this still requires appropriate licensing).

This method is less about embedding a report on a page and more about storing the source file in a shared location. It is best used for version control or giving another report editor access to the source file.

How to Do It:

  1. Navigate to the SharePoint Document Library where you want to store the report.
  2. Drag and drop your .pbix file from your computer into the document library, or use the Upload button.
  3. The file is now stored in SharePoint. A user with the correct permissions can click on the file name, and it will be rendered within the Power BI service experience.

When to use this method: Primarily for backup and versioning of the Power BI file itself. If you want a dynamic visual dashboard on a page, stick with Method 1.

Understanding Permissions: The Most Common Pitfall

Simply embedding a report on a SharePoint page does not automatically give everyone access. This is the source of 90% of all "my report isn't showing up" issues. A user needs two layers of permission to see the embedded report:

  1. Permission to view the SharePoint page itself.
  2. Permission to view the specific Power BI report (and its underlying dataset) inside the Power BI service.

If a user can see the page but gets an error that says "This content isn't available," it means they have #1 but are missing #2. To fix this, you must grant them access within the Power BI service. You can do this by:

  • Giving them direct access via the Share button on the report.
  • Adding them as a "Viewer" to the Power BI workspace where the report is located. For streamlined management, you can add an M365 security group (like your SharePoint Team Site's group) directly to the workspace roles.

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.

Best Practices for a Smooth Experience

Follow these tips to keep your reports secure, organized, and easy for your team to use.

  • Use Dedicated Workspaces: Don't just stuff every company report into a single workspace. Organize them by department, project, or function (e.g., "Executive Dashboards," "Finance Team Reports"). This makes permission management much easier.
  • Leverage Microsoft 365 Groups: Create an M365 Group for your team. This group can be used to manage permissions for both the SharePoint site and the associated Power BI workspace in one go. Add a person to the group, and they get access to everything they need.
  • Filter for Context with URL Parameters: Want to show the same sales report but filtered just for the "East" region on the East Coast team's page? You can! Just add a filter to the URL you paste into the web part. For example: ...&filter=Table/Field eq 'East'. This is a powerful way to provide highly relevant, contextual data without creating dozens of duplicate reports.
  • Optimize for Performance: Large, complex reports can be slow to load, both in Power BI and in SharePoint. Make sure your Power BI data model is efficient and that your visuals are as lean as possible to ensure a quick load time for your users.

Final Thoughts

Embedding Power BI reports into SharePoint is a simple yet powerful way to bring live data directly into your team's collaborative spaces. By using the Power BI web part and carefully managing permissions, you can create a single source of truth that helps drive smarter, data-informed decisions without making users platform-hop.

Building detailed reports in tools like Power BI is often where the real slog happens - connecting data, creating the data model, and painstakingly arranging every visual. At Graphed, we created a way to get past that friction. By connecting your marketing and sales data sources (like Google Analytics, Facebook Ads, or HubSpot), you can build real-time dashboards just by asking questions in plain English. We turn hours of drag-and-drop report building into a 30-second conversation, giving you back command of your time to focus on what the data actually means.

Related Articles