How to Link a SharePoint File to Power BI

Tired of downloading the same SharePoint files every week just to update your reports? There's a much better way. By directly linking your SharePoint files to Power BI, you can create reports that refresh automatically, giving you a live look at your data without the constant manual work. This article will show you exactly how to set up this connection, whether you’re working with a single file, an entire folder, or a SharePoint list.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Connect SharePoint to Power BI Anyway?

While emailing Excel files or downloading CSVs gets the job done, it creates unnecessary work and introduces potential errors. Connecting SharePoint directly to Power BI is a game-changer for a few key reasons:

• A Single Source of Truth: Everyone on your team is working from the same file hosted in SharePoint. When someone updates the central file, the changes flow through to your Power BI report on the next refresh. No more confusion over which version of "Sales_Report_V4_FINAL_Final.xlsx" is the right one.
• Automation Saves Time: Once you publish your report, you can set up a scheduled refresh in the Power BI service. Your data will update daily or even hourly, all without you having to lift a finger. This frees you from the tedious Monday morning routine of downloading, cleaning, and re-uploading data.
• Enhanced Collaboration: Since the master data resides in a shared SharePoint location, your colleagues can update the source data (a project plan, a budget tracker, a sales log) while you focus on building and maintaining the interactive Power BI dashboard that sits on top of it.

In short, it automates the drudgery of reporting so you can spend your time analyzing insights, not wrestling with files.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Option 1: Connecting to a Folder of Files in SharePoint

This is often the most flexible and powerful method, especially if you have multiple files with the same structure - for example, monthly sales exports or weekly performance logs. This method will automatically combine them into one seamless dataset for you.

Step-by-Step Guide:

1. Get Your SharePoint Site URL: Navigate to your SharePoint site's home page. Copy the URL from your browser's address bar, but only the main site part. For example, if your URL is https://yourcompany.sharepoint.com/sites/MarketingTeam/Shared%20Documents/Forms/AllItems.aspx, you only need https://yourcompany.sharepoint.com/sites/MarketingTeam.
2. Open Power BI and Get Data: In Power BI Desktop, go to the Home tab and click Get Data. Click on More… if you don't see the option you need.
3. Select "SharePoint Folder": In the Get Data pop-up window, type "SharePoint" into the search bar. Select SharePoint Folder and click Connect.
4. Paste Your Site URL: You'll be prompted to enter the Site URL. Paste the root URL you copied in the first step. Click OK.
5. Authenticate Your Credentials: The first time you do this, you'll need to sign in. Select Microsoft Account on the left-hand menu, click Sign in, and enter your company Microsoft 365 credentials. Once you're signed in, click Connect.
6. Transform and Combine Your Files: A window will appear showing a list of every single file in that SharePoint site. Don't click "Load"! This would pull everything in. Instead, click Transform Data to open the Power Query Editor.
7. Finalize the Connection: Power BI will ask you for an example file to determine how to combine them (for example, which specific sheet in an Excel workbook you want to use). Select the example and click OK. Power Query will do the heavy lifting of stacking all the files together. From there, you can clean your data as needed and click Close & Apply.

Option 2: Connecting to a Single File From SharePoint

If you only need to connect to one specific file and not a whole folder, the process is slightly different. You'll be using the "Web" data connector and the file's direct path.

Step-by-Step Guide:

1. Find the File and Copy its Path: Go to the SharePoint document library where your file is located. Find the file (e.g., an Excel workbook), click the three dots (...) next to its name, and select Details at the bottom of the menu.
2. Copy the Path: A details pane will open on the right. Scroll down until you see a Path property, and click the copy icon next to it.
3. Clean the URL: This is the most crucial step. Paste the path you copied into a text editor (like Notepad). You'll see it has some text at the end, usually a question mark followed by letters and numbers, like ?web=1. You must delete everything from the question mark to the end.
4. Connect via the "Web" Connector: Back in Power BI Desktop, click Get Data and select Web from the common sources, or search for it if needed.
5. Paste the Clean URL: In the pop-up window, paste the cleaned-up URL you just prepared and click OK. Power BI will then prompt you to sign in with your Organizational account, just as you did in the folder method.
6. Select Your Data: The Navigator window will open, showing you the components of your file. If it’s an Excel file, you'll see a list of sheets and tables. Select the content you need, and then either Load it directly or click Transform Data to clean it up in Power Query first.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Option 3: Connecting to a SharePoint List

Sometimes your data isn’t in a file - it’s in a structured SharePoint List. These lists are essentially simple databases used for calendars, task trackers, or similar purposes. Power BI can connect to these just as easily.

Step-by-Step Guide:

1. Get Data from SharePoint List: In Power BI Desktop, go to Get Data -> More... and search for SharePoint Online List. Select it and click Connect.
2. Enter the Site URL: You'll be asked for the Site URL. Just like with the folder method, this is the root URL of your SharePoint site (e.g., https://yourcompany.sharepoint.com/sites/YourSite).
3. Choose Your List: After you authenticate, the Navigator window will appear, this time showing all the SharePoint Lists available on that site. Select the list you want to use.
4. Load or Transform: From here, you can preview the data. SharePoint lists often contain lots of internal columns that are not useful for reporting. It's almost always a good idea to click Transform Data to go into Power Query. Here, you can remove unnecessary columns, rename existing ones, and ensure the data types are correct before clicking Close & Apply.

Common Issues That Will Cause Connection to Fail

Things don't always go right - it might take a few attempts to learn how to properly link a SharePoint file to Power BI. Here are the most common reasons why connections might fail and how to fix them:

1. Authentication Problems: The first connection doesn’t always go smoothly. We recommend signing out completely on the Power BI modal and then reconnecting your account.
2. Wrong File Destination: When there's a lot of data for a folder, it's important to create the shortest route possible from the source document to its destination folder. A very nested file will take a long time to find within Power BI, and it might just timeout. Move your most valuable SharePoint files you want to sync into smaller folders you designate with your other folders for work, not only to find them faster but to ensure that they connect properly without Power BI being hung out to dry.
3. Not Removing Extra Characters to Sync Individual Links: One common issue that's often overlooked is the presence of extra characters in URLs. When connecting to Power BI via a link, issues often arise due to the original person posting an incorrect URL. To see how a file path should be stripped down to a new URL when moving over from Power BI, see our quick example snippet below:

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Connecting your SharePoint data directly to Power BI is a fundamental step toward building an automated, reliable reporting system. It eliminates time-consuming manual downloads, reduces the chance for human error, and ensures everyone is looking at the most up-to-date information. Whether you're combining monthly reports from a folder or visualizing a live project plan from a SharePoint list, these methods will help you build a solid foundation.

Of course, successfully connecting your data is just the beginning. The real work is in building meaningful visuals and finding insights. Tools like Power BI are incredibly powerful, but there's still a learning curve. Here at Graphed we’ve created a way for anyone to simply use natural language to analyze data. Instead of needing to manually click your way through data connectors, we sync to common data sources so you can tell a dashboard what you want it to show about your data, without even touching any filters at all. Try it risk-free today and you can start getting answers in 30 seconds - you have so much at your fingertips as you get back to managing your work, not having your work manage you.