How to Get Power BI to Update Automatically from Excel

Tired of manually exporting data from Excel and refreshing your Power BI reports every single morning? There’s a much better way. This tutorial will walk you through exactly how to connect your Excel file to Power BI so it updates automatically, keeping your dashboards fresh and saving you hours of tedious work.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Automatic Updates for Excel Data Are a Game-Changer

If you're using Power BI, you're looking for clear, timely insights. But when your dashboards are fueled by Excel files that an intern has to manually update every Monday, your data is stale the moment it’s published. The whole process is fragile, time-consuming, and a recipe for mistakes.

Here’s what you stand to gain by automating the process:

• Save Precious Time: Stop the repetitive cycle of downloading, saving, and republishing reports. An automated refresh means you do the setup work once, and Power BI handles the rest. Half an hour of setup can save you hours every single month.
• Ensure Data Accuracy: Every manual step is a chance for human error - saving the wrong file version, forgetting to update a tab, or simply missing a refresh window. Automation removes this risk, ensuring your stakeholders are always looking at the correct, consistent information.
• Make Faster Decisions: In marketing and sales, timing is everything. A daily, or even hourly, refresh gives you a near real-time view of performance. You can spot trends, catch issues, and react to campaign performance immediately, not a week later when the data finally gets updated.

Manually updating reports is a dead-end job. Automating the report frees you up to do what really matters: analyzing the data and finding insights that actually grow the business.

The Underrated Secret to Automation: Cloud Storage

Before diving into the steps, there's a foundational concept you need to grasp: Power BI’s automatic refresh feature only works with online data sources. If your Excel file is saved on your local "C:" drive or a shared network drive on-premise, the Power BI service (the online version where your dashboards live) has no way to access it without a complex setup called a data gateway.

A data gateway bridges the gap between your local files and the Power BI cloud service. While powerful, it often requires IT support to install and maintain, making it overly complicated for a simple Excel file.

The solution? Move your Excel file to the cloud.

By storing your workbook in a service like OneDrive for Business or SharePoint, the Excel file gets a URL, effectively turning it into a web-based data source. The Power BI service can then connect directly to this URL to pull the latest data, no gateway needed. This is the key that unlocks simple, reliable, automated refreshes.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Connect Power BI to Excel Using OneDrive for Business

Using OneDrive is the simplest method for most people, especially if it's already part of your Office 365 subscription. The refresh happens almost instantly after you save changes to the Excel file in OneDrive.

Step 1: Save your Excel workbook in a OneDrive folder

First, make sure your Excel file is saved in a folder within your OneDrive for Business account. This sounds obvious, but you’d be surprised how many people try this with a personal OneDrive account, which uses a different authentication method and won't work as smoothly. Simply drag and drop the file into a OneDrive-synced folder on your computer or upload it via the web browser.

Step 2: Get the correct file path from Excel

This is the most critical step and where many people go wrong. Do not just open OneDrive in your browser and copy the URL from the top bar. You need a direct file path.

1. Open the Excel file in the desktop application, not in the browser.
2. Go to File > Info.
3. Click on the "Copy path" button. This copies the direct URL to your clipboard.

Now, you need to clean up this path. The URL you copied will look something like this:

https://yourcompany-my.sharepoint.com/personal/your_name/Documents/Reports/Monthly_Sales.xlsx?web=1

For Power BI to use it as a data source, you need to delete the ?web=1 part from the end. The final, clean URL should look like this:

https://yourcompany-my.sharepoint.com/personal/your_name/Documents/Reports/Monthly_Sales.xlsx

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Connect to the file in Power BI Desktop

Now, open Power BI Desktop and get ready to connect to your online Excel file.

• In the Home tab of the ribbon, click Get Data and select Web.
• A dialog box will appear. Paste your cleaned-up Excel file URL into the box and click OK.
• Power BI will ask you to authenticate. Choose "Organizational account" and sign in using your Office 365 credentials.
• After connecting, the Navigator window will appear, showing you all the worksheets and tables in your Excel file. Select the data you need, just like you would with a local file, and then click "Transform Data" or "Load".

Step 4: Publish to the Power BI Service and check credentials

Once your report is built, publish it to a workspace in the Power BI service. After publishing, navigate to that workspace. Find your dataset (it will have the same name as your Power BI file), click the three dots (...), and go to Settings.

Under the "Data source credentials" section, you should see an entry for your Excel file. Click "Edit credentials" and sign in again with your Organizational account using the OAuth2 authentication method. This gives the Power BI service permission to access the file on your behalf.

That's it! With OneDrive, you don't even need to schedule a refresh. Power BI will automatically check for changes about once an hour and update the dataset if the Excel file has been modified. Just save your changes in Excel, and your Power BI dashboard will reflect them shortly.

Method 2: Set Up a Scheduled Refresh Using SharePoint

Using a SharePoint document library is an extremely common scenario for teams that collaborate on files. The connection process is nearly identical to OneDrive, but it gives you more explicit control over the refresh schedule.

Step 1: Upload your Excel file to a SharePoint Document Library

Navigate to your team's SharePoint site and upload the Excel workbook into a document library where your team can access it.

Step 2: Get the SharePoint file path

Just like with OneDrive, you need the direct path to the file.

1. Navigate to the document library where your file is located.
2. Click the three dots (...) next to the file name and select Details.
3. In the details pane that opens on the right, scroll all the way down to the bottom and find the Path section. Click the "Copy direct link" button.

Unlike the OneDrive link, this path typically doesn't need to be cleaned up.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Connect and publish from Power BI Desktop

This process is the exact same as the OneDrive method.

• In Power BI Desktop, go to Get Data > Web.
• Paste the SharePoint direct link URL.
• Sign in using your Organizational account.
• Load your data, build your reports, and publish to the Power BI service.

Step 4: Configure the Scheduled Refresh in Power BI Service

This is where you tell Power BI exactly when and how often you want it to fetch new data from your Excel file.

1. Go to the workspace where you published your report.
2. Find the dataset, click the three-dot menu, and go to Settings.
3. First, make sure your Data source credentials are set up correctly using OAuth2, just as you did in the OneDrive example.
4. Scroll down and expand the "Scheduled refresh" section.
5. Toggle the switch to On.
6. Set Refresh frequency: Choose "Daily" or "Weekly."
7. Set Time zone: Select the correct time zone for your reporting schedule.
8. Add time(s): Click "Add another time" to specify when the refresh should run. For a "Daily" schedule, you can set it to run at 8:00 AM every morning before your team meeting.

The number of refreshes you can schedule depends on your Power BI license. A Pro license allows up to 8 scheduled refreshes per day. A Premium license allows up to 48 per day (every 30 minutes).

Once you’ve configured the schedule, just click Apply. Power BI will now automatically pull the latest data from the Excel file in SharePoint according to the schedule you defined.

Final Thoughts

By moving your Excel files from your desktop to a cloud location like OneDrive or SharePoint, you can unlock Power BI's automatic refresh capabilities. This simple shift turns your static, manually updated dashboards into dynamic, reliable sources of truth that save you time and enable much smarter decision-making.

While an automated Power BI refresh beats manual updates, this entire process highlights the small frictions involved in getting your data connected and live. For our dashboards at Graphed, we’ve designed a system that removes these steps entirely. When you connect a source like Google Sheets, Google Analytics, or Shopify, your data is always live by default - no authentication settings to check or refresh schedules to configure. We believe your time is better spent finding insights, not wrestling with data connections.