How to Get Power BI to Auto Update

Your Power BI dashboard is only as valuable as the data behind it. A report showing last week's numbers isn't a decision-making tool, it's a history lesson. To keep your insights sharp and relevant, you need your data to be current. This article will show you exactly how to set up automatic updates in Power BI, so your reports are always working with the latest information without any manual intervention.

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

Understanding How Power BI Data Refreshes Work

Before jumping into the "how-to," it's helpful to understand the main ways Power BI handles data updates. There isn't just one method for all situations. The right choice depends on your data source and how in-the-moment your reporting needs to be. The two primary methods are Scheduled Refresh and DirectQuery/Live Connection.

Import Mode with Scheduled Refresh

This is the most common method used by Power BI developers. When you use "Import" mode, Power BI takes a complete copy of your data from the source (an Excel file, a SQL database, Google Analytics, etc.) and stores it within the Power BI file itself (.pbix). This makes your reports incredibly fast and responsive because Power BI is querying its own internal, highly compressed copy of the data, not the original source.

The trade-off is that this data is a snapshot in time - it’s only as current as the last time you imported it. This is where Scheduled Refresh comes in. You simply tell the Power BI Service (the cloud-based version of Power BI) to go back to the original data source at regular intervals (e.g., every day at 8 AM) and pull in a fresh copy of the data. This is perfect for most business reporting where daily or hourly updates are sufficient.

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

DirectQuery and Live Connection

DirectQuery and Live Connection are similar concepts for different types of data sources. Unlike Import mode, these methods do not copy and store the data inside your Power BI file. Instead, every time you interact with a visual in your report (like clicking on a filter or a bar chart), Power BI sends a query directly to the original data source in real time. The report then displays the results of that live query.

• DirectQuery: Used for relational databases like SQL Server, a Snowflake data warehouse, or other large cloud data sources.
• Live Connection: Used specifically for SQL Server Analysis Services (SSAS) models, Azure Analysis Services, and Power BI datasets.

The key benefit here is that your data is always perfectly up-to-date. If a new sale is logged in your SQL database, it will appear in your DirectQuery report the next time you look at it. The downside is that reports can feel slower, as they depend on the performance of the underlying data source to return query results.

Which Method Should You Choose?

Here’s a quick guide to help you decide:

• Use Import Mode with Scheduled Refresh when:
• Use DirectQuery or Live Connection when:

For the rest of this guide, we'll focus on setting up a Scheduled Refresh, as it covers the vast majority of business use cases and is the method people typically mean when they ask for "auto-updates."

Setting Up a Scheduled Refresh in Power BI Service

The magic of automated refreshing doesn't happen in Power BI Desktop (the application on your computer). It happens in the Power BI Service, the cloud platform where you share and collaborate on your reports. The process involves publishing your report, configuring your data source credentials, and then setting the schedule.

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: Publish Your Report to Power BI Service

First things first, you need to get your report from your computer into the cloud. Once your report is complete in Power BI Desktop:

1. Make sure you are logged into your Power BI account within the Desktop application.
2. On the Home ribbon, click the Publish button.
3. You'll be prompted to choose a destination Workspace within your Power BI Service. Select the one you want to use.
4. After a brief wait, you'll get a success message. Your report, and more importantly, the underlying dataset, are now in the cloud.

Step 2: Connect to Your Data Source (and set up a Gateway if needed)

This is the most critical step and where most people get tripped up. For the Power BI Service to refresh your data automatically, it needs two things: 1) permission to access your data source, and 2) a path to reach it.

For Cloud-Based Data Sources

If your data sources are all cloud-based (e.g., SharePoint Online, Salesforce, a simple Azure SQL database), the process is straightforward:

1. In the Power BI Service, navigate to the Workspace where you published your report.
2. Find the dataset associated with your report (it will have the same name and a different icon). Hover over it, click the three-dot menu (...) and select Settings.
3. Expand the Data source credentials section. You'll see an "Edit credentials" link for each of your cloud sources.
4. Click it and re-authenticate using the OAuth2 option. This securely grants the Power BI Service permission to log into that source on your behalf to get the data.

For On-Premises Data Sources (The Gateway)

What if your data lives on your local machine or a company server? A common scenario is connecting to an Excel file on your C: drive or a SQL Server database inside your company's firewall. The Power BI Service is in the cloud, it can't see your local computer. To solve this, you need a Power BI Data Gateway.

Think of the gateway as a secure bridge or a tunnel. It's a small, safe piece of software you install on a computer within your network that is always on. It acts as a gatekeeper, receiving refresh requests from the cloud, securely fetching the data from your local source, encrypting it, and then sending it back up to the Power BI Service.

To set up a gateway:

1. Download the On-premises data gateway (standard mode) from the official Microsoft Power BI website.
2. Run the installer on a computer that is always on and connected to the internet (a server is best, but a dedicated desktop can also work).
3. Follow the sign-in and registration prompts, connecting the gateway to your Power BI account.
4. Once the gateway is running, go back to your dataset settings in the Power BI service.
5. Under the Gateway and cloud connections section, you should see your newly configured gateway. You need to map your local data source to it. For example, if your report uses an Excel file, you'll need to provide the file path (e.g., C:\Reports\SalesData.xlsx) and your Windows credentials for that machine.

Pro Tip: The computer running the gateway must be powered on and online for your refresh to succeed. If it's shut down, the Power BI Service won't be able to reach your data, and the refresh will fail.

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

Step 3: Configure the Refresh Schedule

Once your credentials are correct and your gateway (if needed) is mapped, it's time for the easy part: setting the actual schedule.

1. In the same dataset settings page, find and expand the Scheduled refresh section.
2. Toggle the switch to On.
3. Set your Refresh frequency. Depending on your license type, you'll have different options. "Daily" is available for all users. Power BI Pro users can schedule up to 8 refreshes per day, while Premium users can schedule up to 48.
4. Select your Time zone to ensure the refreshes happen at the correct local time.
5. Use the Add another time option to set specific times for the refreshes. For a daily refresh, you might set it for 7:00 AM so the report is ready when your team starts work. For multiple refreshes, you can space them throughout the workday.
6. Finally, check the box under Send refresh failure notifications to. By default, it sends failure alerts to you (the dataset owner), which is highly recommended. You can add others as well. This way, you'll get an email if something breaks, rather than discovering a week later that your data is stale.
7. Click Apply.

That's it! Your report is now set to update automatically. You can always go back to your dataset settings and click "Refresh now" to trigger a manual refresh on demand to test it.

Common Issues and Best Practices

• Refresh Fails on Password Change: The most common cause of a refresh breaking is when the password for a data source changes. If this happens, you just need to go back into the dataset settings and update the stored credentials.
• Report Structure Changes: If you open the .pbix file in Power BI Desktop and make structural changes - like deleting a column that a visual depends on - the refresh will fail. Always publish your changes after modifying the report on Desktop.
• Keep the Gateway Updated: Microsoft regularly releases updates for the on-premises gateway. It's good practice to keep it on a recent version to ensure security and compatibility.
• Optimize Your Data Model: A faster refresh is a healthier refresh. In Power Query, remove any unnecessary columns or rows and perform transformations efficiently. This reduces the amount of data being pushed through the gateway, leading to quicker and more reliable updates.

Final Thoughts

Setting up your Power BI reports to auto-update is a fundamental step in moving from static analysis to dynamic business intelligence. By familiarizing yourself with Import vs. DirectQuery modes and following the steps in the Power BI Service to configure credentials and schedules, you can ensure your team always has access to fresh, actionable data without you having to lift a finger every day.

We built Graphed because we believe getting real-time insights should be even simpler. That process of wrestling with gateways, configuring schedules, and authenticating every single data source is exactly the friction we help you avoid. With our platform, you just connect your cloud data sources like Google Analytics, Shopify, or Salesforce once with a few clicks. Your dashboards update automatically in real-time without you ever needing to think about refresh rates or data pipelines again, so you can spend less time managing settings and more time acting on your data.