How to Upload a Power BI Report to SharePoint

Embedding a Power BI report directly into a SharePoint page gives your team a central, familiar place to view and interact with data. This quick guide will walk you through the process, skip the background noise, and show you exactly how to integrate your reports so they're right where your team collaborates every day.

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?

Before jumping into the "how," it's helpful to understand the "why." Placing your dynamic Power BI reports within your SharePoint environment isn't just a neat trick, it's a strategic move to make your data more accessible, useful, and secure.

Create a Single Source of Truth

When reports live inside SharePoint, your team always knows where to find the latest data. This eliminates the confusion caused by different report versions attached to emails or saved on local drives. Everyone looks at the same dashboard, ensuring decisions are based on consistent, up-to-date information.

Boost Collaboration and Accessibility

Most teams already use SharePoint for document management, project updates, and internal communication. By placing key performance indicators (KPIs) and data visualizations on a team or project site, you put insights directly into their workflow. People can discuss findings and make decisions without ever leaving the platform they use daily, making data a natural part of the conversation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Leverage SharePoint's Security Features

SharePoint Online has robust and granular permissions settings. You can control exactly who has access to the site or page containing your Power BI report. This allows you to leverage SharePoint’s security model as an additional layer to ensure that sensitive business data is only seen by authorized personnel, all managed within your existing Microsoft 365 environment.

Provide Insights in Context

An isolated report only tells part of the story. By embedding a sales report on a sales team's SharePoint page, you place it alongside their monthly goals, project files, and strategy documents. This context helps team members connect the dots between their activities and the results, turning data into more meaningful, actionable insights.

What You'll Need Before You Start

To ensure a smooth process, make sure you have the following in place. This quick checklist will save you from hitting roadblocks later.

• A Power BI Pro or Premium Per User (PPU) License: The creator or admin sharing the report must have a Pro or PPU license. Importantly, anyone viewing the embedded report in SharePoint will also need at least a Power BI Pro license, unless the report is hosted in a Power BI Premium capacity.
• A Published Power BI Report: Your report must be published from Power BI Desktop to a workspace in the Power BI service (app.powerbi.com). You cannot embed a report directly from your desktop PBIX file.
• SharePoint Online Page Permissions: You need permission to edit the modern SharePoint Online page where you intend to add the report. If you don’t have an “Edit” button in the top-right corner of the page, you'll need to ask your site administrator for access.
• SharePoint Online Environment: This method is designed for SharePoint Online (part of Microsoft 365). It won't work with on-premise versions of SharePoint Server.

The Easiest Method: Using the Power BI Web Part

SharePoint Online has a dedicated web part designed specifically for embedding Power BI content. This is the most straightforward and recommended method for a secure, interactive experience.

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

First, you need to grab the unique link that tells SharePoint exactly which report to display.

1. Navigate to the Power BI Service in your web browser and sign in.
2. Open the workspace that contains the report you wish to embed.
3. Click on the report to open it.
4. Once your report is open, go to the menu bar at the top and click File > Embed report > SharePoint Online.
5. A dialog box will appear with a URL specifically formatted for SharePoint. Click the Copy button to copy this link to your clipboard.

This link is essential, as it contains the unique identifiers for your report that the SharePoint web part needs.

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

Now, head over to your SharePoint site to add and configure the component that will host your report.

1. Open the SharePoint site page where you want the report to appear.
2. Click the Edit button located in the top-right corner of the page. This will put the page into edit mode.
3. Hover your mouse over the section of the page where you want to add the report. A horizontal line with a "+" icon will appear. Click the + icon to add a new web part.
4. A search box will pop up. Type "Power BI" into the search field and select the Power BI web part from the list.

A placeholder for the Power BI report will now appear on your page, ready for configuration.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Configure the Web Part with Your Report Link

This is where you connect your SharePoint page to your Power BI report.

1. After adding the web part, a configuration panel will slide out from the right. If it doesn't, click on the Power BI web part on the page, and then click the pencil icon (Edit web part).
2. In the configuration panel, you'll see a prominent button that says Add report. Click it.
3. In the "Power BI report link" field, paste the URL you copied from the Power BI service in Step 1.

After a few moments, you should see a live, interactive version of your Power BI report load directly onto your SharePoint page. No need to click save just yet, you can customize the display first.

Step 4: Customize Your Report's Appearance

The web part offers a few options to fine-tune how the report looks on the page. Use these settings to create the best viewing experience.

• Page name: If your report has multiple pages, you can choose which one to display by default. Just type the exact name of the report page here. If you leave it blank, it will default to the first page of the report.
• Display: This lets you control the report's dimensions. You can choose a standard aspect ratio like 16:9 (widescreen) or 4:3, or select "Fit to page" to make the report responsively fill the width of the page container. "Fit to page" is often the best choice for accessibility across different screen sizes.
• Show navigation pane: This toggle allows you to show or hide the page navigation from the bottom of the Power BI report. If you want users to switch between report pages, leave this on. If you want them to focus on a single summary page, turn it off.
• Show filter pane: Turn this on or off to control the visibility of the Power BI Filters pane. Keeping it on allows users to slice and dice the data themselves directly within SharePoint.

Step 5: Publish Your Changes

Once you are happy with how the report looks, it's time to make it visible to your team.

Click the Republish or Publish button at the top right of the page. Your SharePoint page is now live, featuring your fully interactive Power BI report for all authorized users to see and use.

Troubleshooting Common Issues

Seamless integrations are great, but sometimes things don't go as planned. Here are solutions to a few common hurdles you might encounter.

Problem: Error message says "This content isn't available."

This is almost always a permissions issue. The person viewing the SharePoint page either doesn't have permission to view the report in Power BI, or they lack a Power BI Pro (or PPU) license. Solution: Verify that the user has been granted "Viewer" role access to the workspace in Power BI where the report is located. At the same time, confirm they have an active Power BI Pro or PPU license assigned to their Microsoft 365 account.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Problem: The report appears cut off or distorted.

Your report might look odd if its dimensions don't fit the space well on the SharePoint page. Solution: Edit the SharePoint page, select the Power BI web part, and open its configuration panel. Under the "Display" setting, try changing the aspect ratio. The "Fit to page" option is often the most reliable as it adjusts to the available space.

Problem: I can't find the Power BI Web Part.

If you search for the Power BI web part and it doesn't appear in the list, it has likely been disabled by an administrator. Solution: Contact your SharePoint or Microsoft 365 administrator. They may need to enable the web part at the tenant level or check the site settings to ensure that scripting capabilities, which some web parts rely on, are enabled.

Final Thoughts

You've now successfully embedded a Power BI report into SharePoint, creating a dynamic data hub right inside your team's digital workspace. This simple integration breaks down the barriers between insight and action, making data a central, collaborative part of your daily workflow.

Integrating tools is powerful, but creating those initial reports can often be the bottleneck. At Graphed, we focus on simplifying data analysis from the start. We connect to your marketing and sales platforms (like Google Analytics, Shopify, and Salesforce), letting you create real-time dashboards and reports just by asking questions in plain English. With Graphed, you spend less time wrestling with complex BI software and more time getting answers, which makes sharing those insights - whether in SharePoint or elsewhere - even easier.