How to Load SharePoint File in Power BI

Tired of downloading the latest version of an Excel file to update your Power BI reports? Connecting Power BI directly to a file stored in SharePoint solves this problem for good, creating a refreshable report from a single, collaborative source. This article walks you through the step-by-step process for connecting to a single SharePoint file and even an entire folder of files, plus how to troubleshoot common issues.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Connect SharePoint Files to Power BI?

While you could just upload a local Excel or CSV file to Power BI, connecting directly to a SharePoint source has several significant advantages that make it the professional standard for team-based reporting.

• Single Source of Truth: Everyone on your team works from the exact same file. When someone updates the data in SharePoint, the changes flow directly into your Power BI report on the next refresh. This eliminates confusion caused by having multiple versions saved on different computers.
• Effortless Collaboration: Multiple team members can contribute to and update the source data in SharePoint. Marketing can update their campaign spend, sales can input their latest numbers, and both sets of data are available in the same source file for your report.
• Automatic Report Refreshes: You can schedule your published Power BI report to refresh automatically (up to 8 times a day on a Pro plan). This means your stakeholders are always looking at the latest data without you ever having to manually open Power BI Desktop, refresh, and republish.
• Built-in Version History: SharePoint automatically tracks changes and keeps a version history of your files. If someone makes a mistake or overwrites critical data, you can easily roll back to a previous version of the file, which provides a valuable safety net.

Getting Started: What You'll Need

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

• Power BI Desktop: You'll need the free Power BI Desktop application installed on your computer to build the initial report.
• SharePoint Site Access: You must have permission to access the SharePoint site and the specific file or folder you want to connect to. At a minimum, you will need 'Read' access.
• An Organizational Microsoft Account: Your login for Power BI and SharePoint should be the same work or school account (e.g., yourname@yourcompany.com).

Method 1: How to Connect a Single Excel or CSV File

This is the most common method when your data is contained within a single, regularly updated file. The trickiest part is getting the correct URL - follow these steps carefully.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Get the Right File Path from SharePoint

Power BI needs a direct link to the file, not the preview link you get from your browser's address bar. Here's how to find the proper path.

1. Navigate to your SharePoint document library and locate the file.
2. Click the three dots (...) next to the filename, then go to Details at the bottom of the menu.
3. A pane will open on the right. Scroll down to the bottom and find the Path section. Click the copy icon next to the path to copy it to your clipboard.

Now, paste this URL into a text editor like Notepad. You will see it ends with something like ?web=1. You must delete this part.

For example, your copied URL might look like this:

https://yourcompany.sharepoint.com/sites/Marketing/Shared%20Documents/Reports/Monthly_Sales.xlsx?web=1

You need to shorten it to this:

https://yourcompany.sharepoint.com/sites/Marketing/Shared%20Documents/Reports/Monthly_Sales.xlsx

This clean URL is what you will use in Power BI.

Step 2: Connect via "Get Data" in Power BI

With your clean URL copied, it's time to pull the data into Power BI Desktop.

1. Open Power BI Desktop.
2. On the Home ribbon, click Get Data and select Web from the dropdown menu.
3. In the "From Web" dialog box, paste your cleaned URL from Step 1 and click OK.
4. Power BI will then ask you to sign in. In the "Access web content" window, select the Organizational account option on the left.
5. Click Sign in and enter your Microsoft 365 credentials if prompted.
6. Once signed in, click Connect.

Step 3: Load Your Data

After a successful connection, the Navigator window will appear. It shows you all the available tables and worksheets inside your Excel file.

• Select the tables or sheets you want to load by checking the boxes next to their names. Power BI will show you a preview on the right.
• If your data looks clean and ready for analysis, click Load. If you need to clean it up (e.g., remove columns, change data types), click Transform Data to open the Power Query Editor first.

That's it! Your report is now directly connected to the Excel file living in SharePoint.

Method 2: How to Connect a SharePoint Folder of Files

What if your data is split across multiple files? For example, a new sales report CSV is added to a folder each month. The "SharePoint Folder" connector is incredibly powerful for this scenario, allowing you to combine them all into one master table.

Step 1: Get the SharePoint Site URL

Unlike connecting to a single file, this method requires the main URL for the SharePoint site, not the URL of the folder itself. Navigate to the homepage of your SharePoint site and copy the URL from your browser's address bar. It should look something like this:

https://yourcompany.sharepoint.com/sites/YourSiteName

It's important not to include anything that comes after the site name (like /Shared%20Documents/...).

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Connect to the SharePoint Folder Connector

Now, let's head back to Power BI Desktop.

1. Click Get Data > More...
2. In the Get Data window, search for and select SharePoint folder, then click Connect.
3. Paste your SharePoint Site URL from Step 1 into the dialog box and click OK.
4. You may be prompted to sign in. Just like before, choose Organizational account, sign in, and click Connect.

Step 3: Combine Your Files in Power Query

After connecting, a different type of preview window appears, showing a list of all files found on that SharePoint site. Don't worry, you'll filter this down.

1. A list of all files and metadata will appear. Click the Transform Data button to open the Power Query Editor.
2. First, filter the list to only include the files you want. The two most useful columns for filtering are Folder Path (to isolate your specific folder) and Extension (to select only ".xlsx" or ".csv" files). Click the dropdown arrow on the column headers to apply your filters.
3. Once you’ve filtered the list to a few uniform files, find the column named Content and click the Combine Files icon (two small downward arrows) in its header.
4. Power Query will now guide you through the combine process. It will ask you to select a sample file as a template for how to extract the data. Choose the correct worksheet or table (e.g., Sheet1).
5. Click OK. Power Query will work its magic, applying the extraction steps to every file in your filtered list and appending them all into a single, unified table. Power Query automatically adds a Source.Name column so you can see which file each row came from.

You can now perform any additional data transformations before clicking Close & Apply to load your master table into Power BI.

Common Issues and Troubleshooting Tips

Connecting to SharePoint can sometimes be tricky. Here are solutions to the most frequent problems people encounter.

"Access to the resource is forbidden" or Credential Errors

This is almost always an authentication issue. When the "Access web content" window appears, Power BI sometimes defaults to "Anonymous." You must manually select "Organizational account" and sign in with your company credentials. If that doesn't work, go to File > Options and settings > Data source settings, find your SharePoint data source in the list, and click "Clear Permissions" to start over.

Using the Wrong URL

This is the number one cause of failed connection attempts. Double-check your URLs:

• For a single file: Did you use the Path copied from the Details pane? Did you delete the ?web=1 suffix at the end?
• For a folder: Are you using the root Site URL (e.g., https://yourcompany.sharepoint.com/sites/SalesTeam) and not the direct link to the folder itself?

Graphed

Still Building Reports Manually?

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

Watch the Demo

Scheduled Refresh Fails in Power BI Service

Your report refreshes fine in Power BI Desktop, but it fails after you publish it online. This is because the Power BI Service needs its own credentials to access SharePoint.

To fix this, go to your workspace in the Power BI Service, find your dataset, click the meatballs menu (...) and select Settings. Under "Data source credentials," you'll see an alert for the SharePoint source. Click Edit credentials, use OAuth2 as the Authentication method, Privacy Level Organizational, and sign in with your account. The scheduled refresh should now work.

Final Thoughts

Connecting Power BI directly to data in SharePoint is a foundational skill for building efficient, automated, and collaborative business reports. By leveraging a centralized source - whether a single file or a whole folder - you eliminate manual downloads and ensure everyone is making decisions based on the same up-to-date information.

While setting up these connections is a huge time-saver, managing dozens of data sources and building complex reports can still get cumbersome. At Graphed we simplified this process entirely. We connect all your marketing and sales data sources (like SharePoint, but also Google Analytics, Shopify, Salesforce, etc.) in one click. Then, you can simply ask for the dashboard you need in plain English – like "Show me a dashboard of monthly sales from our SharePoint file compared to our sessions on Google Analytics." and we instantly build a live, shareable dashboard for you.