How to Connect Excel Online to Power BI

Tired of manually exporting your Excel data and re-uploading it every week to update your reports? There’s a much smarter way. By connecting your online Excel files directly to Power BI, you can create dashboards that refresh automatically, saving you hours and ensuring your entire team is looking at the most current data. This article will walk you through exactly how to set up this powerful connection.

Graphed

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.

Build Your First Agent

Why Connect Excel Online to Power BI Anyway?

Before diving into the steps, it's helpful to understand the benefits. Manually moving data is tedious, but connecting these two tools fundamentally changes your reporting workflow from a static, manual chore into an automated, dynamic system. It’s a huge time-saver and a significant step up for your data analysis process.

• Automate Your Reporting: Once you set it up, the connection is always live. Any changes you make in your Excel spreadsheet on SharePoint or OneDrive will automatically appear in your Power BI dashboards after the next scheduled refresh. No more downloading, no more uploading - just up-to-date data.
• Create Rich, Interactive Visualizations: Power BI goes far beyond static Excel charts. You can build interactive reports where users can click on a bar in a chart to filter the entire dashboard, drill down into details, and uncover insights that are much harder to spot in a spreadsheet.
• Combine Data from Multiple Sources: The real power comes in when you combine that Excel sales data with information from other tools. You can pull in your Google Ads campaign data, Shopify store performance, and QuickBooks financials all into one Power BI dashboard. This gives you a complete, unified view of your business performance that’s impossible to achieve in a single spreadsheet.
• Share Insights Securely: Instead of emailing sensitive Excel files around (creating version control nightmares and security risks), you can publish a secure Power BI report. Team members can view and interact with the dashboards without ever needing access to the raw data file, giving you complete control over who sees what.

Getting Started: A Few Prerequisites

To ensure a smooth connection, you just need a couple of things in place. Taking a minute to check these beforehand will save you a lot of trouble down the line.

1. Your Excel File Location Matters

This method works specifically for Excel files saved in a cloud location tied to your business Microsoft account. You cannot connect an Excel file saved on your local hard drive and expect it to refresh online automatically.

You’ll need to store your Excel workbook in either:

• OneDrive for Business
• SharePoint Online (e.g., a Teams document library)

If your file is currently on your C: drive, just upload it to one of these locations before you begin.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

2. Format Your Data as a Proper Excel Table

While you can connect to a sheet, Power BI works much better when your data is formatted as an official Excel Table. This makes the data structured and named, so Power BI can identify the headers and data range reliably, even if you add new rows later.

If your data isn't already in a table, it’s a quick fix:

1. Click any cell inside your data range in Excel.
2. Go to the Insert tab in the ribbon.
3. Click Table.
4. Excel will likely guess your data range. Confirm it’s correct and be sure the checkbox for "My table has headers" is checked.
5. Click OK.

It's also a good idea to give your table a descriptive name. To do this, click anywhere in the table, go to the Table Design tab, and type a new name in the "Table Name" box on the far left (e.g., SalesDataQ3). This will make it much easier to identify in Power BI later.

Connecting Power BI Desktop to a Single Excel Online File

This is the most common method, used to connect to a specific, primary reporting file like your main sales tracker or marketing budget sheet.

Graphed

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.

Build Your First Agent

Step 1: Get the Correct Path to Your File

This is the step that trips up most users. You can’t just use the browser URL or the "Share" link. You need a direct path that Power BI can understand. Here's how to get it:

1. Navigate to your SharePoint or OneDrive for Business folder where the file is stored.
2. Click the three dots next to your Excel file and choose "Open in App" to launch the file in your desktop version of Excel.
3. Once open in desktop Excel, go to File > Info.
4. Right below the file name, you'll see a button that says Copy Path. Click it.

This copies a long URL to your clipboard. It will look something like this: https://yourcompany.sharepoint.com/sites/Marketing/Shared%20Documents/2024%20Reporting/SalesTracker.xlsx?web=1

Step 2: Connect via the 'Web' Connector in Power BI

Now, open Power BI Desktop.

1. From the Home ribbon, click Get Data and select Web.
2. A dialog box will appear. Paste the path you copied from Excel.
3. Here's the essential trick: Look at the very end of the URL you pasted and delete the ?web=1 text. Power BI needs the clean file path, and that query string can cause authentication failures.
4. Click OK.

Step 3: Authenticate and Select Your Data

Power BI now needs to authenticate with your Microsoft account to gain access to that file location.

1. An authentication window will pop up. Select Organizational account from the options on the left.
2. Click Sign in and log in with your normal work (Microsoft 365) email and password.
3. After successfully signing in, click Connect.
4. The Navigator window will appear, showing you the contents of your Excel file. Remember how you formatted your data as a named Table? You’ll now see that table listed clearly with a blue header icon. You may also see the raw sheets listed (with a different icon).
5. Click the checkbox next to your named Table. A preview of the data will appear on the right so you can confirm it looks correct.
6. Finally, click Load.

Power BI will now load the data from your Excel file, and you’ll see the table appear in the ‘Fields’ pane on the right-hand side, ready for you to start building visuals.

Advanced Method: Combining Multiple Excel Files with the SharePoint Folder Connector

What if your data is split across multiple files? For example, maybe you get a new sales export every month (Jan-Sales.xlsx, Feb-Sales.xlsx, etc.) all saved in the same folder. The SharePoint Folder connector is perfect for this.

1. In Power BI Desktop, click Get Data and search for/select SharePoint folder. Click Connect.
2. Power BI will ask for a site URL. Provide the root URL of your SharePoint site. Don't link to the specific folder, just the main site. For example: https://yourcompany.sharepoint.com/sites/Marketing.
3. After authenticating, a Navigator window will appear showing a list of every single file in that entire SharePoint site. This can look overwhelming. Click Transform Data to open the Power Query Editor.
4. Inside Power Query, you can filter this list down to exactly what you need. First, use the "File Path" column to filter to your specific subfolder. Then, filter the "Extension" column to only show ".xlsx" files.
5. Once you have a clean list of only the Excel files you want to combine, look for the column named Content. Click the Combine Files button (a small icon with two downward arrows) in the header of that column.
6. Power BI will now analyze the files. A new dialog will pop up asking for an example. Select your key data Table from the sample file that appears. Click OK.
7. Power Query will automatically perform all the necessary steps to open each file, extract the specified table, and append them all into one master table.
8. Once you’re happy with the preview, click Close & Apply from the Home ribbon.

Now, even if you add a new monthly Excel file to that SharePoint folder in the future, all you have to do is refresh your Power BI report, and it will automatically pick up and combine the new data.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Publishing and Setting Up Automatic Refresh

Connecting your data is only half the battle. The real magic happens when you set up an automatic refresh schedule online.

1. Once your report is ready in Power BI Desktop, click the Publish button on the Home ribbon.
2. Select a Workspace in the Power BI Service to publish to.
3. After it succeeds, go to app.powerbi.com in your browser and navigate to the Workspace where you published the report.
4. Find your dataset, not the report. Datasets and reports have different icons. Hover over your dataset name, click the three dots (...) that appear, and select Settings.
5. Expand the Data source credentials section. Click "Edit credentials" and sign in again using your Organizational account (with OAuth2 as the authentication method). This gives the Power BI cloud service ongoing permission to access your file.
6. Next, expand the Scheduled Refresh section.
7. Toggle the switch to On.
8. Choose your Refresh frequency (e.g., Daily), select your time zone, and add the specific times of day you want the report to refresh.
9. Click Apply.

That's it! Your report is now fully automated. Any change made to the source Excel file in OneDrive or SharePoint will be picked up and displayed in your live Power BI report at the next scheduled time.

Final Thoughts

Connecting your Excel Online files to Power BI moves you from tedious manual reporting to a streamlined, automated workflow. It lets you build powerful, interactive dashboards based on data that's always current, giving you and your team more time to focus on deriving insights instead of wrangling data files.

Learning tools like Power BI is incredibly valuable, but it often involves a lot of clicks, credential management, and setting up workflows manually. If you want to jump straight to the insights without all the setup, we built Graphed to simplify this entire process. You just connect your data sources - like Google Analytics, Salesforce, or even Google Sheets that can be synced with Excel files - with a single click, and then ask for what you need in plain English. Instead of building reports step-by-step, you can just ask, "Show me last quarter's sales trends by region," and get a live, interactive dashboard in seconds.