How to Refresh Power BI

Keeping your Power BI reports and dashboards updated is essential for making timely decisions. With multiple options available, it can be confusing to know which refresh method to use and how to set it up correctly. This guide will walk you through the different ways to refresh your data in both Power BI Desktop and Power BI Service, including how to automate the entire process so your data is always current.

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

Understanding the Basics: Power BI Refresh Types

Before diving into the "how-to," it's helpful to understand what happens when a refresh is triggered. Power BI doesn't just have one type of refresh, depending on your setup and what you click, different actions happen behind the scenes.

• Model/Data Refresh: This is the most common and important type. It involves Power BI connecting to your original data sources (like an Excel file, a SQL database, or Google Analytics) and loading the latest data into your dataset. This updates all the visuals that rely on that dataset.
• Package Refresh: This synchronizes your Power BI Desktop file with the Power BI Service. It refreshes not just the data, but also any model changes, new reports, or visualizations you've built. This happens when you publish or republish a .pbix file.
• Tile Refresh (for dashboards): Dashboard tiles are essentially snapshots from your reports. By default, they don't automatically check for new data after every model refresh. The tile refresh specifically updates the cache for a dashboard's visuals, ensuring they reflect the latest data from the dataset. This usually happens automatically about every hour for tiles connected to datasets that use Import mode, or whenever a model refresh occurs.
• Visual Container Refresh: This refreshes an individual report visual within Power BI Service. It's often triggered automatically as users interact with the report, updating the visual cache with any recent changes.

Most of the time, when we talk about "refreshing Power BI," we are focusing on the model/data refresh - ensuring the underlying data is up-to-date.

How to Refresh Your Data in Power BI Desktop

Power BI Desktop is where you build your reports, and manually refreshing your data here is the first step before publishing to the cloud. The process is relatively simple.

In the Home ribbon of Power BI Desktop, you'll see a prominent "Refresh" button. Clicking this tells Power BI to reach out to all the data sources defined in your report and pull in the latest information.

However, what happens when you click "Refresh" depends heavily on your data source's Storage Mode:

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

1. Import Mode

This is the most common method. When you use Import mode, Power BI takes a complete copy (a snapshot) of your data from the sources and stores it within the .pbix file itself. This is great for performance because Power BI's own internal engine (the VertiPaq engine) can query this local copy incredibly fast.

• When you click "Refresh": Power BI discards the old data snapshot and queries your original sources to import a brand new one.
• Use Case: Use this for most scenarios where data doesn't need to be live down-to-the-second, like analyzing data from Excel files, CSVs, or periodically updated databases.

2. DirectQuery Mode

In DirectQuery mode, Power BI does not store a copy of the data. Instead, it only stores the metadata (like table names and column names). Every time you click on a visual or a slicer, Power BI generates and executes a query directly to your underlying data source in real-time.

• When you click "Refresh": This action does something slightly different in DirectQuery. It clears any caches and forces every visual in your report to re-query the source, ensuring you're seeing the absolute latest data. However, you often won't even need to click it, as visuals request new data automatically.
• Use Case: Perfect for very large datasets that cannot fit in memory or situations that require real-time or near real-time data, like operational dashboards connected to a SQL database.

3. Live Connection

This is similar to DirectQuery but is specific to a handful of data sources, primarily SQL Server Analysis Services (SSAS) and Power BI datasets.

Here, you are creating a live connection directly to an existing data model. Power BI doesn't merely access a database - it mirrors the entire model structure from the source. As a result, the "Refresh" button in Power BI Desktop is typically disabled in this mode because all refreshing logic is managed at the source.

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

Automating Refreshes in Power BI Service

Manually refreshing your data in Desktop and republishing is fine occasionally, but it's not a scalable solution. The real power of Power BI comes from automating this process online with Power BI Service. This is how you ensure the reports your stakeholders are viewing are always current, without you lifting a finger every morning.

To do this, you need to set up a scheduled refresh for a published dataset.

Step 1: Get Your Data Gateway Ready (For On-Premises Data)

If your data sources are cloud-based (like Google Sheets, an Azure SQL Database, or Salesforce), they are directly accessible by Power BI Service. However, if your data resides within your company's private network (an "on-premises" source) - like a local SQL Server or an Excel file on a shared network drive - Power BI needs a secure way to access it.

This is where the data gateway comes in. Think of it as a secure bridge between your private, on-premises data and Microsoft's cloud.

1. Download and Install: Download the standard On-Premises Data Gateway from Microsoft. You'll need to install this on a computer that is almost always on and connected to your company network.
2. Sign In and Configure: Once installed, you'll be prompted to sign into your Power BI account. Name your gateway and provide a recovery key (store that safely!).
3. Check Status: Once completed, the gateway is active and ready to be configured in the Power BI Service.

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

Step 2: Configure Your Dataset Settings

After publishing your report from Power BI Desktop to Power BI Service, find your dataset in the destination workspace.

1. Navigate to your workspace in the left navigation bar.
2. Click on the ellipsis (three dots) next to your dataset and select Settings.
3. Gateway connection: In the Settings panel, you'll see a "Gateway connection" option. If a gateway is required, expand this section. You should see your newly installed gateway in the dropdown list. Map the gateway to each of your data sources.
4. Data Source Credentials: Expand the section called Data Source Credentials. For each data source, you'll need to click "Edit credentials" and provide Power BI permissions to access it. For cloud sources like Salesforce, this often means signing in with OAuth2. For a SQL Server, this may involve entering a username and password.

Step 3: Schedule the Refresh

With the credentials in place, you can finally schedule the refresh.

1. In the same Dataset Settings panel, scroll down and find the Scheduled refresh section.
2. Click the toggle switch to turn it on.
3. Refresh frequency: Choose either Daily or Weekly.
4. Time: You can add multiple time slots throughout the day by clicking "Add another time." Keep in mind: Power BI Pro accounts are limited to 8 refreshes per day, while Premium capacity accounts get up to 48 refreshes per day.
5. Notifications: It's a good practice to check the box to Send refresh failure notifications. This way, you'll receive an email if something goes wrong.

Once you apply these settings, Power BI will automatically attempt a data refresh at the scheduled times you specified.

Performing an On-Demand Refresh ("Refresh Now")

Sometimes you can't wait for the next scheduled refresh. Perhaps a crucial sales report was just updated and you need to see its impact immediately. For this, you can use the Refresh Now function.

• Navigate to your workspace in Power BI Service.
• Find the dataset or report you want to refresh.
• Next to your dataset name, you'll see two icons: one for a scheduled refresh, and the other for Refresh Now (a circular arrow).
• Click the Refresh Now icon. Power BI will immediately queue the refresh. You'll see a spinning icon next to the dataset name to indicate it is actively updating.

Troubleshooting Common Refresh Errors

If a scheduled refresh fails, you will get an email notification detailing the error. Here are the most common issues and how to fix them.

• Credential errors: This is the most frequent problem. Re-check your stored credentials for each data source - especially any that have changed passwords recently.
• Gateway issues: Ensure the data gateway is running correctly on its host machine and that there is no network outage.
• Timeouts: The refresh is taking too long - especially for large datasets. Consider reducing the amount of queried data or moving to a higher Power BI Premium capacity if necessary.

Final Thoughts

Power BI refreshes are essential for ensuring that your analytics provide a timely and accurate view of key metrics. By understanding the structure behind Power BI Service and automating refresh processes, you can deliver real-time insights to your team without a hitch. Power BI stands out as a robust tool for business intelligence and data visualization, easily customizable for various needs.