How Many Types of Refresh in Power BI?

Keeping a Power BI report updated seems simple enough until you realize there are multiple ways to "refresh" your data. Understanding the difference between a dataset refresh, a visual refresh, and an automatic page refresh is crucial for ensuring your reports are both accurate and efficient. This guide will walk you through the various types of Power BI refresh, helping you understand what each one does and when you should use it.

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

Before You Refresh: Understanding Data Connectivity Modes

Before diving into the types of refresh, you must first understand how your report connects to its data source. Power BI offers different connectivity modes, and the one you choose fundamentally determines your refresh options.

Import Mode

When you use Import mode, Power BI takes a copy of your data from the source and stores it inside the .pbix file. This highly compressed copy is loaded into memory when you interact with the report, making visualizations incredibly fast.

• How it works: Data is extracted, transformed, and loaded into your Power BI model.
• When to use it: This is the most common and often best-performing mode. It's ideal for most business reports where real-time data is not a strict requirement, such as weekly sales summaries or monthly marketing campaign analyses.
• Refresh implications: Because the data is a static copy, you must perform a data refresh to see new or updated information from the source.

DirectQuery Mode

With DirectQuery, Power BI doesn't store a copy of the data. Instead, it sends queries directly to the source database every time a user interacts with a visual. Your report is essentially a thin visual layer on top of a live database.

• How it works: No data is imported. Visualizations send live queries to the source.
• When to use it: Use DirectQuery when dealing with very large datasets that won't fit into memory or when your reports absolutely must reflect the most current state of the data (e.g., monitoring a manufacturing line or a call center queue).
• Refresh implications: The concept of a "data refresh" is different here. You don't schedule a data import. Instead, visuals refresh themselves periodically or when a user applies a filter, pulling the latest data automatically.

Live Connection Mode

Live Connection is similar to DirectQuery but is specifically for connecting to SQL Server Analysis Services (SSAS), Azure Analysis Services (AAS), or Power BI datasets. Like DirectQuery, no data is copied into the report.

For most scenarios, your choice will be between Import and DirectQuery. This decision is the foundation for understanding what kind of refresh your report needs.

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

Type 1: Data Model Refresh (The Full Refresh)

This is what most people think of when they talk about a refresh in Power BI. A data model refresh updates the entire dataset for reports using Import Mode. It goes back to the original data source (an Excel file, a SQL database, your Shopify account, etc.), pulls in the latest data, and updates the copy stored in Power BI.

There are two ways to trigger a data model refresh:

Manual (On-Demand) Refresh

As the name implies, this is a refresh you start yourself. In the Power BI Service, you can navigate to your Workspace, find your dataset, and click the refresh icon next to its name.

• When to use it: Ideal for one-off situations when you've just updated a source file or need the most current numbers before a big meeting. For example, if your finance team just posted the final monthly sales numbers to a shared spreadsheet, you can trigger a manual refresh to pull them into your P&L report immediately.
• How to do it: In Power BI Service, go to a workspace, hover over the dataset you want to refresh, and select the Refresh now icon.

Scheduled Refresh

A scheduled refresh automates the process. You can configure Power BI Service to update your dataset on a specific schedule, such as every morning at 8:00 AM or every four hours throughout the business day.

• When to use it: This is the best practice for almost all routine reporting. This ensures your key performance dashboards are always ready for your team review at the start of the day without any manual effort.
• How to set it up: Go to the dataset's settings, expand the "Scheduled refresh" section, toggle it on, and choose the frequency and time(s) for the automatic refresh.

Keep in mind: Your capabilities and limitations depend on your Power BI license:

• A Power BI Pro license lets you schedule up to 8 automated refreshes per day.
• A Power BI Premium license gives much greater functionality, supporting up to 48 refreshes per day.

Important Note: For both manual and scheduled refresh to work on data sources that are located on-premise (like a local server in your office), you will need to set up and configure a data gateway. This gateway acts as a secure bridge, allowing the cloud-based Power BI Service to communicate with your local data sources.

Type 2: Visual, Tile, and Dashboard Refresh

This is a source of frequent confusion. When you're looking at a dashboard in the Power BI Service, refreshing a tile or the whole dashboard does not trigger a data model refresh. Instead, it refreshes queries to the dataset already stored in Power BI's cache. So in the event some data has become available due to an issue with the dataset, once this refreshes, users should be able to access the latest cached updates once a visual or a tile is refreshed.

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

What does this actually mean in practice?

Imagine your dataset is scheduled to refresh every day at 8:00 AM. At 8:15 AM, you open your dashboard. The data you see is from the 8:00 AM refresh. If source data changes at 9 AM, your dashboard won’t reflect those changes automatically until it's refreshed next. In a similar vein, clicking refresh at 9:30 will simply redraw the dashboard with the data from the 8 AM refresh instead of triggering another dataset refresh. In essence, tile and dashboard refreshes are great for fetching cached info, not necessarily real-time information whenever new events happen.

By default, dashboard tiles refresh automatically about once per hour if the underlying dataset is updated. You can also manually refresh the entire dashboard by clicking the "Refresh" button in the upper-right menu. Again, this action queries the existing, cached dataset, it does not query the original data source.

Type 3: Automatic Page Refresh

For reports using DirectQuery and Live Connection mode, Automatic Page Refresh provides near-real-time monitoring. This feature lets you set a specific refresh interval for a report page, causing all visuals on that page to re-query the data source automatically.

• What it is: A report-level setting that automatically refreshes all visuals on a page at a fixed frequency (for example, every 5 seconds or every 10 minutes).
• When to use it: This is perfect for command center-style dashboards where monitoring critical, fast-changing data is essential. Think about tracking performance on a factory floor, monitoring stock market data, or watching incoming support tickets in a customer service center.
• How to set it up: In Power BI Desktop, select the report page (click the blank canvas), go to the Formatting pane, and you will find the "Page refresh" option. Here you can toggle it on, set the type to "Auto page refresh," and define the interval. Note: How frequently users can refresh data can be limited via controls imposed by Power BI's Admins in your organization.

This is fundamentally different from a scheduled data refresh. A scheduled refresh updates a dataset's cached data. An automatic page refresh simply tells a DirectQuery report to ask the live data source for new data again and again.

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

Type 4: Package Refresh

A package refresh is the most straightforward but also the most "manual" method. Essentially, it just means you're re-publishing your .pbix file from Power BI Desktop to the Power BI Service. When you do this, you overwrite the existing version of the report and the dataset with whatever is in your local .pbix file.

• What it does: Effectively refreshes both the report structure and the data in one fell swoop. The data included will be as fresh as the last refresh you performed in Power BI Desktop before publishing.
• When to use it: Typically used during development when you are making significant changes to the report layout, adding new visuals, writing new DAX measures, or performing transformations in Power Query. You build and test locally, then publish the new package to deploy all your changes.
• What to be aware of: Publishing from Power BI Desktop will overwrite any changes, or dashboard tiles (pinned visuals) which are linked to a given report.

This is a “blunt force” approach which might result in additional post-publishing work that has the potential to break or remove the ability for end-users to access specific visuals after a fresh deploy has taken place from your computer, therefore it requires additional checks after deployment.

Which Power BI Refresh Type Should You Use?

Choosing the right refresh method boils down to your reporting needs. Here's a simple way to decide:

1. For most standard business reports (weekly sales, monthly financials): Use Import Mode with a Scheduled Refresh configured in the Power BI Service. This provides great performance and reliably fresh data without manual effort.
2. When you need to update a report immediately outside its schedule: Use a Manual (On-Demand) Refresh on the dataset.
3. For dashboards that need to monitor operations in near-real-time (factory output, server status): Use DirectQuery Mode and configure Automatic Page Refresh on your report page.
4. When you're actively developing and changing a report's structure and visuals: Use Package Refresh by republishing your file from Power BI Desktop.

Final Thoughts

Understanding the difference between refreshing the dataset versus refreshing report visuals is the most important lesson in managing Power BI reports effectively. By selecting the right data connectivity mode and refresh type at the start, you ensure your stakeholders get timely, accurate data while optimizing performance and your own workflow.

While Power BI’s refresh options are powerful, setting up gateways, managing schedules, and troubleshooting can still consume significant time, particularly when dealing with dozens of marketing, sales, and operations platforms. We built Graphed to simplify this entire process. We connect directly to your data sources and maintain live, real-time dashboards automatically - no refresh schedule required. You can simply ask for the chart you need in plain English ("show me conversions by campaign for last month"), and we build an interactive dashboard that stays updated for you.