How Often Does Power BI Refresh Data?

Nothing is more frustrating than making a business decision based on a report that's using last week's data. To get real value from your dashboards, the information needs to be current, which is why understanding Power BI's refresh schedule is so important. This guide will walk you through exactly how often your data can be updated, the different ways to refresh it, and how to set everything up.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Is a Data Refresh in Power BI?

A data refresh in Power BI is the process of updating the data within your datasets with the latest information from the original data sources. When you create a report in Power BI Desktop, you connect to various data sources - like a Google Sheet, a web API, a SQL database, or a CRM. Most of the time, Power BI makes a copy of that data and stores it within your Power BI file (this is called "Import mode").

But that copied data is just a snapshot in time. The original data back in your Google Sheet or CRM continues to change. A "refresh" is what bridges that gap. It tells Power BI to go back to the original source, grab all the new and updated information, and bring it into your report's dataset to keep your charts and visuals current.

This is different from DirectQuery or a Live Connection, which don't import a copy of the data. Instead, they query the data source directly every time a user interacts with the report. We'll touch on those later, but for now, we'll focus on the much more common Import mode, which relies on scheduled refreshes.

Power BI Refresh Types and Frequency Limits

The core question - "how often can my data refresh?" - depends almost entirely on your Power BI license and the capacity your workspace is on. What works for a free user is very different from what's possible with a top-tier Premium plan.

Power BI Pro Refresh Limits

For users with a Power BI Pro license, you are able to schedule up to 8 refreshes per day, per dataset. These refreshes have to be scheduled on the half-hour or hour mark (e.g., 9:00 AM, 9:30 AM, 10:00 AM). You get to choose the times that make the most sense for your business.

• Maximum Refreshes: 8 per 24-hour period.
• Scheduling: On the hour or half-hour.
• Example: You could set a dataset to refresh every hour between 9:00 AM and 4:30 PM to keep your daily sales report fresh during business hours.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Power BI Premium Per User (PPU) and Premium Per Capacity Refresh Limits

When you step up to a Power BI Premium plan - either Premium Per User (PPU) or Premium Per Capacity - your refresh capabilities increase significantly. This is designed for larger organizations or those who need more timely data updates.

Users with a Premium license can schedule up to 48 refreshes per day, per dataset. The key difference here is the increased frequency, you can schedule refreshes as often as every 30 minutes, 24/7. More importantly, with Premium, you gain access to the XMLA endpoint, which unlocks the ability to trigger refreshes through other tools and provides much more granular control outside the standard scheduling interface.

• Maximum Refreshes: 48 per 24-hour period.
• Scheduling: No longer restricted to the hour/half-hour mark. You can schedule a refresh for any time (e.g., 9:05 AM, 9:15 AM).
• Key Advantage: This high frequency is perfect for reports that track fast-moving metrics, like website traffic, ad campaign performance, or operational dashboards.

It's important to remember that these limits are per dataset. If you have 10 different datasets in your workspace, you can apply these refresh schedules independently to each one.

On-Demand (Manual) Refreshes

Beyond scheduled refreshes, Power BI always allows for manual refreshes. By navigating to your workspace and finding your dataset, you can hit the "Refresh Now" button at any time. This is perfect for when you need to see the absolute latest data immediately after a big sales call or right before walking into a meeting.

Crucially, manual refreshes do not count toward your daily limit of scheduled refreshes. A Pro user can kick off manual refreshes as needed in addition to their 8 scheduled ones. However, Power BI does impose a fair use policy to prevent abuse, but for typical business needs, this is rarely an issue.

How to Set Up a Scheduled Data Refresh

Configuring a refresh schedule is a straightforward process you do in the Power BI Service (the web-based version), not in Power BI Desktop. Here's how to do it step-by-step.

Step 1: Publish Your Report

First, you need to publish your completed report from Power BI Desktop to a workspace in the Power BI Service. Once it's published, both the report and its underlying dataset will appear in that workspace.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Navigate to Dataset Settings

In the Power BI Service, find the workspace where you published your report. Hover over the dataset you want to refresh (not the report itself) and click the three dots (...), then select Settings.

Step 3: Provide Data Source Credentials

Power BI needs permission to access your original data sources. Under the "Data source credentials" section, you'll see a list of every source you connected to. Click "Edit credentials" for each one and securely sign in. This is a one-time setup that gives the Power BI service permission to pull data on your behalf.

Step 4: Configure the On-Premises Data Gateway (If Needed)

If your data sources are located "on-premises" (meaning on a local computer or a server within your company's network, like a local SQL server or an Excel file on a shared drive), the cloud-based Power BI Service can't reach them directly. This is where the On-premises data gateway comes in.

The gateway is a small piece of software you install on a computer within your network that securely bridges the gap between your local data and the Power BI Service. After you connect your dataset to a configured gateway, Power BI can use it to reach in and grab the data for refreshes.

If all of your data sources are already in the cloud (like Google Analytics, Salesforce, or an Azure SQL database), you can skip this step.

Step 5: Set Your Refresh Schedule

This is where you tell Power BI how often to refresh. In the settings, find the "Scheduled refresh" section and toggle it on.

• Refresh frequency: Choose "Daily" or "Weekly."
• Time zone: Select your appropriate time zone to ensure refreshes run at the correct local time.
• Time: Click "Add another time" to schedule your refresh slots. Remember, as a Pro user, you have 8 slots available, as a Premium user, you have 48.

You can also set up refresh failure notifications. It's a good practice to toggle on the option to "Send refresh failure notifications to me." This way, if a source file moves or credentials expire, you'll get an email alert letting you know the refresh failed so you can fix it.

The Real-Time Alternative: DirectQuery and Live Connection

For some use cases, even 48 refreshes per day isn't fast enough. If you need a dashboard that reflects data changes in a matter of seconds, you'll want to use a different data connectivity mode instead of Import.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is DirectQuery?

With DirectQuery, Power BI doesn't import and store a copy of the data. Instead, it sends a query directly to the supported data source every time a user interacts with a report (e.g., clicking a slicer or filtering a chart). The visuals are then rendered with the live data.

• Pros: Data is always current. It's great for extremely large datasets that are too big to import.
• Cons: Report performance can be slower since it depends on the speed of the underlying data source. There are some limitations in data modeling and DAX functions.

What is a Live Connection?

A Live Connection is similar to DirectQuery but is specifically used to connect to pre-built data models, such as SQL Server Analysis Services (SSAS), Azure Analysis Services (AAS), or another Power BI dataset. Like DirectQuery, no data is imported, and interactions query a live source.

For both of these modes, you can enable Automatic Page Refresh in Power BI Desktop before publishing. This feature allows you to set a specific timed interval (as frequently as every second on Premium capacity) to automatically refresh all the visuals on a report page, creating a true real-time monitoring experience.

Practical Tips for Managing Your Refreshes

As you build more reports, managing your data refreshes efficiently becomes key. Here are a few best practices:

• Stagger Your Schedules: If you have multiple important datasets, try to schedule their refreshes at different times (e.g., one at 9:00 AM, another at 9:05 AM in Premium). This avoids putting a heavy load on your Power BI capacity or your data sources all at once.
• Refresh Only What's Needed: Not every report needs to be updated 8 times a day. For weekly or monthly summary dashboards, a single daily or even weekly refresh is often sufficient. Use your refresh slots wisely on the reports that need it most.
• Monitor Refresh History: A few times a month, check the "Refresh history" for your critical datasets. This will show you a log of every refresh attempt and whether it was successful or failed, helping you spot recurring issues before they become major problems.
• Consider Incremental Refresh (Premium): For gigantic datasets, refreshing the whole thing every hour can be slow and resource-intensive. Incremental refresh is a Power BI Premium feature that allows you to only refresh new or changed data, making the process faster and more efficient.

Final Thoughts

Understanding how often your Power BI data refreshes is fundamental to building trust in your reports. The frequency is tied directly to your license - 8 times a day for Pro and 48 times for Premium - while real-time needs can be met with DirectQuery or Live Connections. By properly configuring gateways, credentials, and schedules, you can ensure your team always has the fresh data it needs to make smart, timely decisions.

While Power BI is incredibly powerful, managing refresh schedules, gateways, and credentials across a dozen different marketing and sales platforms can still become a painful, manual chore. At Graphed, we automate the worst parts of reporting. Since we connect directly to your data sources like Google Analytics, Shopify, and Salesforce, your dashboards are always live and updated in real time - no refresh schedules needed. You can even build an entire cross-platform report just by asking for it in plain English, which lets you focus on finding insights instead of wrestling with technical settings.