Can Power BI Auto Refresh?

Nothing sours a good report faster than stale data. The whole point of building a Power BI dashboard is to give stakeholders a live, accurate view of business performance, but that value disappears if you're manually re-uploading spreadsheets every morning. The good news is that yes, Power BI can absolutely refresh its data automatically. This article walks you through exactly how to set up what’s called a “Scheduled Refresh” in the Power BI Service. We’ll cover what it is, the step-by-step process for getting it running, and how to troubleshoot common issues you might run into along the way.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Scheduled Refresh in Power BI?

A Scheduled Refresh is a feature within the Power BI Service (the online version of Power BI) that automatically updates the data in your reports from its original sources at times you define. Instead of you opening Power BI Desktop, clicking "Refresh," and republishing your report every day, you can tell Power BI to do it for you — up to 8 times a day on a Pro license or 48 times a day on a Premium license.

This is the key to turning your Power BI dashboard from a static snapshot into a dynamic, living tool that people can rely on for timely insights. It automates the most tedious part of reporting: keeping the data current.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Start: Import vs. DirectQuery

How Power BI handles refreshes depends heavily on how you connect to your data in the first place. There are three main modes, but for auto-refresh, you'll mostly deal with these two:

• Import Mode: This is the most common method. Power BI takes a copy of your data and stores it within the .PBIX file. Because it’s a copy, it needs to be refreshed to see any changes from the source. Scheduled Refresh is designed for Import Mode.
• DirectQuery Mode: With this method, Power BI doesn't copy the data. Instead, it sends queries directly to the source database every time a user interacts with a report. Your data is always "live" because there's no stored copy to refresh. You can still schedule a cache refresh, but it functions differently and is less about updating stale data.

This tutorial will focus on the far more common scenario: setting up a scheduled refresh for a dataset using Import Mode.

How to Set Up a Scheduled Refresh: Step-by-Step

Automating your data refresh involves a few key steps. It all happens within the Power BI Service, so the first step assumes you've already built your report in Power BI Desktop.

Step 1: Publish Your Report to the Power BI Service

The refresh happens in the cloud, so your report needs to be there first. Once your report is ready in Power BI Desktop:

1. On the Home ribbon, click Publish.
2. Select a destination workspace in the Power BI Service. (e.g., "My workspace").
3. Once it's published, you'll get a success message with a link to open the report online. Click it to navigate to the Power BI Service.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Install and Configure a Data Gateway

This step is only necessary if your data sources are on-premises, meaning they live on a local computer or company server (like a local SQL Server database or an Excel file on your C: drive). If your data is from a cloud source (like Google Analytics, Azure SQL, or a SharePoint file), you can usually skip to Step 3.

So, what is a gateway? Think of it as a secure bridge. It's a small piece of software you install on a computer within your local network that allows the cloud-based Power BI Service to securely reach back and "pull" data from your local sources.

Installing the On-premises Data Gateway:

1. In the Power BI Service, click the settings gear icon in the top-right corner and select Download > Data Gateway.
2. This will take you to the download page. Download the Standard mode gateway.
3. Run the installer on a computer that is always on and connected to the internet (a server is ideal, but a dedicated desktop works too). A gateway can't work if the machine it's on is asleep or turned off.
4. Follow the on-screen instructions. You'll sign in with your Power BI account to register the gateway with your tenant.

Step 3: Add Your Data Sources to the Gateway

Once the gateway is installed, you need to tell Power BI which credentials to use to access your specific data sources through it.

1. In the Power BI Service, go to Settings > Manage Connections and gateways.
2. Select the On-premises data gateways tab. You should see the gateway you just installed.
3. Inside the gateway settings, add your data source. For example, if you connected to an Excel file on your local machine, you’ll define that file path and provide the Windows username and password for the user who has access to that folder.
4. This tells Power BI: "When you want data from this source, use this gateway and authenticate with these credentials."

Step 4: Configure the Scheduled Refresh on Your Dataset

With publishing and gateway configuration out of the way, you can finally set the schedule. This is done at the dataset level, not the report level.

1. In the navigation pane of the Power BI Service, find your workspace and locate your dataset. It will have the same name as your report and an orange icon.
2. Click the three dots (...) next to the dataset name and select Settings.
3. Expand the Gateway and cloud connections section. Make sure your on-premises sources are mapped to the gateway connection you configured. For cloud sources, you'll need to enter your credentials here directly (e.g., your login for a cloud database).
4. Expand the Scheduled refresh section.
5. Toggle the switch to On.
6. Choose your preferred Refresh frequency (Daily or Weekly).
7. Select your Time zone. This is important so the refresh runs when you expect it to.
8. Click + Add another time to set the specific times you want the refresh to run. On a Pro plan, you can add up to 8 per day.
9. Check the box under Send refresh failure notifications to get an email if something goes wrong.
10. Click Apply.

That's it! Your Power BI report will now automatically update at the times you scheduled, pulling fresh data from your sources without you ever having to lift a finger.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Common Roadblocks and Troubleshooting Tips

Setting up a scheduled refresh can sometimes hit a snag. Here are some common issues and how to solve them:

• Gateway is Offline: The most common issue. This happens if the computer hosting the gateway is turned off, asleep, or loses internet connectivity. Ensure the machine is always-on and the "On-premises data gateway service" is running in Windows Services.
• Data Source Credential Errors: If your password changes for a database or even your Windows login, the stored credentials in the Power BI Service will fail. You'll need to go to the dataset settings and re-enter the correct credentials for that data source.
• Refresh Timed Out: For very large datasets, the refresh can sometimes take longer than the allowed time (typically 2 hours on a shared capacity). The best solutions here are to optimize your data model in Power BI Desktop, filter out unneeded data in Power Query before it's imported, or upgrade to a Power BI Premium capacity for longer timeout limits.
• Underlying File Path Changed: If an Excel or CSV file on a local or shared drive is moved or renamed, the refresh will fail because it can't find the source. Always use a stable location for your source files and update the data source path in Power BI if it ever changes.
• Refresh Frequency Limits: Remember the limits: 8 refreshes per 24-hour period for Pro and 48 for Premium. If you need more frequent updates, you may need to look into a DirectQuery connection for true real-time data.

Final Thoughts

Setting up a scheduled refresh is the single most important step in turning a Power BI report from a one-off analysis into a reliable decision-making tool. By publishing your report and properly configuring your data sources and gateways, you can ensure your team always has the latest data ready for them.

While Power BI’s refresh capabilities are powerful, setting up and maintaining gateways and credentials across multiple sources can still involve a lot of management. For teams drowning in data from platforms like Google Analytics, Shopify, HubSpot, and various ad managers, we've found that this process is often a major roadblock. Instead of learning complex BI tools and a dozen different data schemas, you can use Graphed to connect your sources with a few clicks and build real-time dashboards just by describing what you need in plain English. Your data stays live automatically without you ever having to think about refresh schedules, so you can spend less time wrangling data and more time acting on it.