How to Auto-Refresh a Published Power BI Dashboard with Local Data

If you’ve ever published a Power BI dashboard online and found yourself stuck with outdated visuals that won’t refresh automatically, you’re not alone. One of the most common issues planning engineers and data analysts face is getting dashboards to auto-refresh when the data source lives on a local machine, such as an Excel or CSV file stored on your hard drive.

In this article, we’ll explain why this happens and walk you through how to solve the problem by installing and configuring the Power BI On-Premises Data Gateway.

The Problem: Local Files Don’t Refresh in Power BI Service

When you build a dashboard using Power BI Desktop, it’s common to use local datasets, for example, a progress report in Excel or a resource histogram that reads the data from an XER file directly. Once you publish your .pbix file to the Power BI Service (your online workspace), everything looks great, you share the link with your stakeholders, and they can access the dashboard easily.

If you don’t know how to do that, you can check our Power BI Course that takes you from scratch into building advanced dashboards and publishing them online in order to make them available 24/7 for all stakeholders.

Here are some of the reviews on the course. You can find them at the course page:

Abdul Qadir: “The “Power BI Monitoring and Controlling with P6” course by Hany Ismail, a seasoned Planning Director, is nothing short of amazing! This course offers real-world, project-based learning that bridges the gap between Primavera P6 and Power BI, providing practical insights into monitoring and controlling project performance. Hany’s expertise and hands-on teaching style make the concepts easy to understand and immediately applicable to real projects. The blend of data visualization and project control techniques is a game-changer for professionals looking to enhance their analytical and reporting skills. I highly recommend this course to all project control professionals—it’s a must-have for anyone aiming to stay ahead in their field!”

Haitham Fekry: “A heartfelt thank you to Dr. Hany Ismael for his dedication, expertise, and effort in delivering such an exceptional course. I’m truly grateful for this opportunity to learn from one of the best in the field.”

But after publishing your dashboard online, when you update your local Excel file, you’ll notice something annoying: the dashboard does not reflect the updated data, even if you click refresh in the Power BI Service.

The Reason: Why My Published Power BI Report Can’t Connect to Local Data?

Because Power BI Service is cloud-based, it has no direct access to your local files or folders. It doesn’t “see” your hard drive. That’s why the semantic model cannot refresh unless you give it a secure path to do so. But what does a semantic model even mean?

What is a Semantic Model in Power BI?

Before we continue, it’s important to understand what Power BI actually publishes when you click “Publish” in Power BI Desktop. What goes to the cloud is not just the report visuals, it’s the semantic model (previously known as the “dataset”).

A semantic model is a structured layer that sits between your raw data and your report visuals. It includes:

• Data tables (from Excel, SQL, etc.)
• Relationships between tables (e.g., linking progress to activities)
• Measures and calculated columns (e.g., Total Planned %, Earned %, SPI)
• Visuals Hierarchies (e.g., WBS levels or calendar hierarchy)
• Formatting and metadata

When you publish a Power BI file, the semantic model is what gets stored in the Power BI Service. This model is what powers your visuals online, and it’s what gets refreshed during scheduled updates.

If the data source can’t be reached (like a local file not connected via a gateway), the semantic model can’t be updated, and that’s when dashboards become outdated.

Understanding this architecture helps you realize that Power BI dashboards aren’t refreshing raw files directly; they’re refreshing the semantic model, which must have a live or accessible data source to update.

Source: Datacamp.com

So if you checked your Power BI workspace, you’ll find for each dashboard you built and published, a semantic model and a report. The semantic model gets the data from different sources, does the calculations and relations between tables, and gives the output to the visuals in the report in order to present it.

The Solution: Use the On-Premises Data Gateway

The official solution from Microsoft is to install the Power BI On-Premises Data Gateway. This software acts as a bridge between your local computer and the Power BI Service in the cloud. Once set up, it allows scheduled or on-demand refreshes of your dashboard using your local dataset.

The following simple report is created on Power BI desktop and published to the Power BI workspace. When you open your workspace, you’ll find something like this.

This tells us that the dataset is an Excel sheet called “Dataset”, it gives the data to a Semantic Model, which is connected to the final report called “Projects Cost Report”. The report is a simple table showing the cost of 4 projects as follows:

Let’s go back to our Excel Dataset on the local hard drive, and delete the Project D data and save.

Now let’s get back to our workspace and try to refresh the semantic model.

RECOMMENDED COURSE

Power Bi Monitoring and Controlling with P6

Microsoft Power BI is very easy software. However, it is magically solved the slow performance of excel for large data, added new…

• 1,194 students
• WhatsApp support group
• Certificate

View course

The semantic model can’t be refreshed as it doesn’t have the permission to connect to your local drive to get the data from the Excel Dataset.

The Solution: How to Set Up the Gateway

Here’s how to make it work: go to your semantic model settings.

Under “Gateway and cloud connections”, you’ll see that you don’t have any data gateways.

Click on “Install now” under “Cloud Connections”

A software will be downloaded to your PC. Install it as follows:

Check the “I accept” check box and click Install

Add the email that you use to access the workspace that has the semantic model

Get back to your semantic model settings, you’ll see that the personal gateway appears and is running on your PC.

Go to “Data source credentials”, you’ll see the Excel sheet that has your data. Click on edit credentials to give the model access to the sheet.

It’ll ask you about the privacy level that you need, choose the level you want then Sign in.

Now try to refresh the semantic model again, you’ll find that it’ll take time and be refreshed.

Go to the report, you’ll find that it’s updated with the new data and Project D is deleted as we did in the Excel sheet.

Now, each time the dataset on your local drive is updated, you need to go to your Power BI workspace and refresh the semantic model with the new data.

What if you want the report to be refreshed automatically daily or weekly? Is it possible?

Yes, it’s possible, you can adjust the semantic model settings to auto refresh each time period or at a specific time.

In order to do that, go to the semantic model settings.

Under “Refresh” you will find the following:

You can choose the time zone, frequency, and specific time that you want your model to be refreshed at.

Auto-Refresh Limitations and Best Practices

• The PC running the gateway must be online for the refresh to work.
• If the file path or file name changes, the refresh will fail.
• Always publish your .pbix file from the same machine where the file is stored. Why?

When you publish a .pbix file to Power BI Service, it captures the exact file path of your data source — including the drive letter, folder path, and file name — as it appears on your local machine. For example: C:\Users\Shrief\Documents\Progress Reports\Week 15.xlsx

This path becomes part of the semantic model and is used by the Power BI Service (via the Gateway) to locate and refresh the file.

So What Happens If You Publish from a Different Machine?

Let’s say the original Excel file is on your laptop at: C:\Users\Shrief\Documents\Week 15.xlsx

But then you open the same .pbix file on another machine (like a desktop or colleague’s PC) and publish it from there, where the path is different, say: D:\Project Data\Week 15.xlsx

Now, Power BI will think the dataset is linked to that new file path (D: drive), not the original one. As a result:

The gateway won’t find the file because it’s pointing to a path that doesn’t exist on the machine where the gateway is installed.

Scheduled refresh will fail with an error like: “The path is not accessible or does not exist.”

You’ll have to go back to the Power BI Desktop, repoint the data source, and re-publish again.

If multiple users need access or automation is critical, consider moving the dataset to OneDrive, SharePoint, or SQL Server for more flexibility.

By setting up the On-Premises Data Gateway, you ensure that your published Power BI reports reflect the latest data without needing to re-publish manually every time.

It’s a simple but essential setup that can save you hours and keep your project team aligned with real-time insights.

Download Article Resources

How to Auto-Refresh a Published Power BI Dashboard with Local Data 857.62 KB 584 downloads

This File is included in the following course(s)

Power Bi

---

Keep in Touch

Join our Email Newsletters and receive FREE weekly useful content!

Your Name

Email

---

Related posts:

How to Edit the Activity name to include the Floor in 3 methods How to Create a Simple Power BI Report What are the differences between Cost Control and Cost Estimation Solutions for the Error Message While Importing an Excel Sheet to P6 What are the CSI 16 Divisions of Work