Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Refresh Visuals in Power BI

Cody Schneider••6 min read

Nothing is more frustrating than updating your data source, turning back to your Power BI report, and seeing... exactly the same numbers. When your visuals don't update to reflect the latest information, it can feel like the report is broken. This article will show you exactly how to refresh visuals in both Power BI Desktop and Power BI Service, and explain the difference between a data refresh and a visual refresh.

GraphedGraphed

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.

Watch Graphed demo video

Why Your Visuals Aren't Updating Automatically: The Two Types of "Refresh"

Before diving into the "how," it's important to understand what's happening behind the scenes. Power BI has two different types of refreshes that work together. Understanding this distinction is the key to solving most refresh-related headaches.

1. Data Model Refresh

This is the big one. A data model refresh is when Power BI reaches out to your original data source (an Excel file, a SQL database, Google Analytics, etc.) and pulls in the latest data. When you use Power BI in Import mode (the most common method), you are taking a snapshot of your data and loading it into your Power BI file (.pbix). That snapshot is static, it doesn’t automatically know when the underlying source file has changed. A data model refresh is the action of taking a new, updated snapshot.

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.

2. Visual Refresh (Cache)

To keep performance fast and snappy, Power BI stores the results of your report visuals in a visual cache. When you click between report pages, the visuals load instantly because they are pulled from this temporary memory. A visual refresh clears this cache and forces Power BI to re-query the already-loaded data model to redraw the charts and tables. This happens almost instantly and doesn't involve going back to the original data source.

So, if your chart isn't showing new sales numbers from your Excel file, the problem is most likely the data model, not the visual cache. You need to tell Power BI to go fetch the new data from Excel first.

How to Refresh Visuals in Power BI Desktop

Power BI Desktop is where you build your reports. Refreshing the data here is a manual process, but it's very straightforward.

The Main "Refresh" Button

This is your primary tool for updating everything. Clicking it performs a full data model refresh for every single source in your file.

  1. Find the Refresh button in the "Home" ribbon at the top of the window.
  2. Click it. A small window will pop up showing the progress as Power BI connects to each data source and updates the tables.
  3. Once it completes, all visuals in your report will automatically update to reflect the newly imported data.

This single click handles both the data model refresh and the subsequent visual refresh. Use this whenever you've updated your source data and want to see the new information in your report.

GraphedGraphed

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.

Watch Graphed demo video

Refreshing a Single Table

What if you have dozens of tables from various sources, but only one Excel file has changed? A full refresh can be time-consuming. You can save time by refreshing just the single table you need.

  1. Go to the Fields pane on the right side of your screen.
  2. Hover your mouse over the name of the table you want to update.
  3. Click the three dots (...) that appear.
  4. Select Refresh data from the menu.

Power BI will now only refresh that specific table, which is much faster for large and complex reports.

How to Refresh in Power BI Service (Automated & Scheduled Refreshes)

Once you publish your report to Power BI Service (the web-based version), you gain powerful options to automate the refresh process so you and your team are always looking at the latest data.

Setting Up a Scheduled Refresh

A scheduled refresh tells Power BI to automatically perform a data model refresh on a cadence you define - for example, every day at 8:00 AM. This is perfect for standard business reporting.

  1. After publishing your report, navigate to your workspace in Power BI Service.
  2. Find your dataset (it will have the same name as your report and an orange icon). Hover over it, click the three dots (...) and select Settings.
  3. Expand the Data source credentials section. You may need to edit and re-enter your credentials for Power BI Service to be able to access your data source on your behalf.
  4. Once credentials are set, expand the Scheduled refresh section.
  5. Toggle "Keep your data up to date" to On.
  6. Set the Refresh frequency (Daily or Weekly), your Timezone, and add the Time(s) you want the refresh to occur.
  7. Click Apply.

That’s it! Power BI will now automatically update your dataset according to the schedule you set, ensuring your published report always shows current information.

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.

Automatic Page Refresh for Real-Time Visuals

What if you need a visual on a dashboard to be closer to real-time, like for monitoring production lines or live website traffic? A scheduled refresh every 15-30 minutes might not be enough. For this, Power BI has a feature called Automatic Page Refresh.

This is a setting you configure on a specific report page back in Power BI Desktop before publishing:

  1. In Power BI Desktop, click on a blank part of the report page you want to auto-refresh.
  2. Go to the Format pane (the paintbrush icon).
  3. Find the Page refresh card at the bottom. Turn it On.
  4. Set the refresh type to Auto page refresh and choose your desired interval (e.g., every 1 minute).

Heads up: This feature works best with DirectQuery data sources, which have a live connection to the data, rather than Import mode. Using it heavily with imported data can put a high load on your Power BI capacity.

Final Thoughts

Ensuring your Power BI visuals are current comes down to understanding the difference between updating the data model and refreshing the visual cache. Whether you’re manually hitting "Refresh" in Desktop or setting up an automated schedule in Service, you now have the tools to keep your reports accurate and trusted.

The challenges of setting up data gateways and managing refresh schedules are why we built Graphed. We wanted to remove the manual busywork associated with reporting. With Graphed, we automate the entire live connection process. You just connect your sources like Google Analytics, Shopify, or your CRM one time, and your dashboards are always pulling real-time data automatically - no refresh schedules, gateways, or manual updates required.

Related Articles