How Often Can Power BI Refresh?

The frequency of data refreshes in Power BI isn't a one-size-fits-all answer, it depends entirely on your specific license, the data connection method you’re using, and the features you have enabled. This article breaks down exactly how often you can refresh your Power BI datasets, from daily schedules to real-time updates, so you can choose the best option for your needs.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding Data Connection Modes is the First Step

Before we talk about refresh schedules, you need to understand the three fundamental ways Power BI connects to your data. Your choice here is the biggest determining factor for how "live" your data can be.

1. Import Mode

This is the most common and versatile mode. When you use Import Mode, Power BI takes a full copy of your data from the source (like an Excel file, a SQL database, or a SaaS platform) and loads it into its high-performance in-memory engine. Think of it like taking a snapshot of your data at a point in time.

• Pros: Excellent performance because the data is self-contained within Power BI. You can use the full power of DAX (Data Analysis Expressions) for complex calculations.
• Cons: The data isn't live. It's only as fresh as the last refresh. This is where set refresh schedules come into play. There are also limits on the size of the dataset (e.g., 1 GB for Pro, up to 400 GB for Premium).

When to use it: Most standard BI dashboards and reports use Import Mode. It's perfect when you don't need second-by-second data and can happily operate with data that’s refreshed a few times a day.

2. DirectQuery Mode

With DirectQuery, Power BI doesn't import or store a copy of your data. Instead, it acts as a visualization layer on top of your existing data source. Every time a user interacts with a report (slices, filters, etc.), Power BI sends a query directly to the source database to fetch the latest data.

• Pros: Your report always shows near real-time data from the source. There are no dataset size limitations since the data isn’t stored in Power BI.
• Cons: Report performance is entirely dependent on the speed of the underlying data source. If your database is slow, your report will be slow. DAX functionality is more limited compared to Import Mode. It can also put a significant load on your source system.

When to use it: DirectQuery is ideal for reports built on very large datasets (multi-terabytes) or for scenarios where having real-time data is critical, like in operational monitoring dashboards.

3. Live Connection Mode

Live Connection is similar to DirectQuery but is exclusively for a specific set of sources: SQL Server Analysis Services (SSAS), Azure Analysis Services (AAS), and Power BI Datasets. In this case, Power BI connects to an existing data model. You don't create a new model in Power BI Desktop, you just connect to the one that's already been built and managed elsewhere. The data processing, relationships, and measures all live in the source model.

• Pros: Leverages powerful, enterprise-grade data models that can be shared across many reports. It ensures a single source of truth for your business logic.
• Cons: All modeling and measures must be handled in the source Analysis Services cube, not in Power BI Desktop.

When to use it: Use Live Connection when your organization has already invested in creating a mature semantic model in Analysis Services or wants to create thin reports on top of an existing certified Power BI dataset.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Scheduled Refresh Limits for Import Mode Datasets

When most people ask about refresh frequency, they're typically using Import Mode and want to schedule a regular data snapshot. The limits for these scheduled refreshes are defined by your Power BI license.

Power BI Free

Users with a Free license cannot schedule automatic refreshes in the Power BI Service. To update a dataset, you must manually trigger a refresh in Power BI Desktop and then republish the .pbix file to the service. There is no automated option.

Power BI Pro

A Power BI Pro license allows you to schedule up to 8 refreshes per dataset per 24 hours. You can configure these refresh times in the dataset settings in the Power BI Service. For example, you could set your report to refresh roughly every 3 hours (e.g., 6 AM, 9 AM, 12 PM, 3 PM, etc.). You can also trigger an on-demand refresh at any time using the "Refresh now" button, which does not count against your 8-per-day limit.

Power BI Premium Per User (PPU)

A PPU license significantly increases the limit, allowing for up to 48 scheduled refreshes per dataset per 24 hours. This means you can freshen up your data every 30 minutes around the clock. Like the Pro license, on-demand refreshes are unlimited and don't count towards this 48-slot limit.

Power BI Premium Capacity

Datasets in a Premium capacity also get up to 48 scheduled refreshes per day using the standard scheduling interface. However, the key benefit of Premium is that it unlocks more advanced refresh capabilities beyond the simple UI scheduler, which allows you to bypass these limits for truly frequent updates.

Going Beyond Scheduled Refreshes: Options for Faster Data

What if refreshing every 30 minutes still isn't fast enough? Power BI offers several advanced features for near real-time and real-time scenarios.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The XMLA Endpoint (Premium Feature)

With a Premium license (PPU or Capacity), you get access to the XMLA endpoint. This is a powerful feature that allows external tools like SQL Server Management Studio (SSMS) and scripting tools (like PowerShell or Azure Automation) to manage your Power BI datasets. Using the XMLA endpoint, you can trigger refreshes programmatically. This means you are not bound by the 48-refreshes-per-day limit of the scheduler UI. You could script a solution to refresh a dataset every 5 minutes if your Premium capacity can handle the resource load.

Automatic Page Refresh (For DirectQuery & Live Connection)

Automatic Page Refresh doesn't refresh the entire dataset, instead, it refreshes the visuals on a specific report page at a set interval. This is an excellent feature for monitoring dashboards where you want visuals to update automatically without user interaction. It only works with DirectQuery or Live Connection sources.

It comes in two flavors:

• Fixed Interval: You define a specific interval (e.g., every 5 minutes). On a standard workspace, the minimum interval is 30 minutes. In a Premium workspace, this can be set as low as every one second.
• Change Detection: A more efficient method where you define a specific measure that Power BI will query at an interval. If the measure's value has changed, Power BI will then refresh all the visuals on the page. This reduces the number of queries sent to your data source.

Real-time Streaming & Push Datasets

For true, up-to-the-second real-time data, you can use Power BI Streaming datasets. This works completely differently than the other methods. Instead of Power BI pulling data from a source, you push data into a Power BI dataset using the REST API. As soon as the data is pushed, it's available in the report visuals.

This is designed for high-velocity data scenarios, such as:

• IoT sensor data from a factory floor.
• Live social media A/B test results.
• Real-time monitoring of service application logs.

Practical Tips for Managing Your Refreshes

Knowing the options is half the battle. Here’s how to apply that knowledge efficiently.

1. Choose the Right Connection Mode For Your Goal

Don't default to DirectQuery just because you think you need "live" data. Ask yourself if data refreshed every hour (or even 8 times a day via Import Mode) is sufficient. For most strategic dashboards, it absolutely is. Import Mode will deliver far better performance and a richer analytical experience. Reserve DirectQuery for genuinely operational reports based on massive data sources that demand real-time views.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Stagger Your Refresh Schedules

If you're a Power BI administrator, avoid scheduling all of your important datasets to refresh at the same time (e.g., 9:00 AM on the dot). This can create a resource bottleneck and cause refreshes to queue up or fail. Stagger them throughout the hour, such as at :05, :15, and :30, to distribute the load on your capacity and data gateway.

3. Always Configure Refresh Failure Notifications

In the dataset settings, make sure you check the box to "Send refresh failure notifications." By default, it sends an email to the dataset owner, but you can also add other stakeholders. There's nothing worse than finding out your key sales report has been showing stale data for three days because the refresh has been quietly failing.

4. Understand Refresh Timeouts

Dataset refreshes aren't instantaneous and can time out. In a shared capacity (Pro), the timeout is 2 hours. In a Premium capacity, the timeout is 5 hours. If your data source is slow or your transformations in Power Query are very complex, you might hit these limits. Always optimize your queries to ensure they run efficiently.

5. Check the Refresh History

If you suspect a problem, you can view the refresh history for any dataset. This screen shows you a log of every scheduled and on-demand refresh, indicating whether it succeeded or failed, how long it took, and providing error messages for troubleshooting failures.

Final Thoughts

Power BI offers incredible flexibility in data freshness, from manual updates to real-time streams straight from a factory floor. Selecting the right refresh frequency involves balancing your need for current data with performance, license cost, and the capabilities of your data source. Understand the difference between Import and DirectQuery first, then align your chosen schedule with your license limits and business goals.

For all its power, setting up and maintaining Power BI can feel like a job in itself, especially when your data is spread across different platforms like Google Analytics, HubSpot, and Salesforce. We created Graphed to remove that friction. We connect directly to your marketing and sales data sources, providing always-on, real-time dashboards that update automatically. Instead of setting up schedules and gateways, you just ask Graphed what you want to see in plain English, and it builds the report for you in seconds.