How to Update Power BI Dashboard

A Power BI dashboard is only as valuable as the data behind it, and outdated information can lead to poor decisions. Keeping your reports fresh and accurate is a core part of the data analysis process. This guide will walk you through the different ways to update your Power BI dashboards, from simple manual refreshes to setting up fully automated schedules in the Power BI Service.

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

Data Refreshes in Power BI: What You Need to Know First

Before clicking the refresh button, it’s helpful to understand a few key concepts that determine how your dashboard gets new data. The right method depends on where your data lives and how the report was built.

Power BI Desktop vs. Power BI Service

The refresh process is different depending on where you are working:

• Power BI Desktop: This is the application on your computer where you build your reports. Refreshing here pulls the latest data into your local .pbix file. This is great for development and testing, but it doesn't automatically update the published report your team sees.
• Power BI Service: This is the cloud-based platform (app.powerbi.com) where you share and collaborate on your reports. This is where you set up scheduled, automated refreshes so your published dashboards are always current, without you needing to do anything manually.

Data Connection Types Matter

Power BI can connect to data in several ways, and the connection mode directly impacts how refreshes work.

• Import Mode: This is the most common mode. Power BI takes a copy of your data from the source (like an Excel file or database) and stores it within the Power BI file itself. Because it's a snapshot in time, you must perform a refresh to see an updated version of the data.
• DirectQuery: In this mode, Power BI doesn't store a copy of the data. Instead, it queries the data source directly every time a user interacts with a visual. Dashboards are essentially live, so there’s no need for "scheduled refreshes." However, performance depends entirely on the speed of the underlying data source.
• Live Connection: This is similar to DirectQuery but is specifically for connecting to tabular models like SQL Server Analysis Services (SSAS) or Azure Analysis Services (AAS). Again, data is live, and no scheduled refreshes are needed.
• Composite Models: This allows you to combine Import Mode and DirectQuery in the same report, giving you the best of both worlds. Refresh schedules would apply to the tables using Import Mode.

For the rest of this guide, we'll focus on Import Mode, as it's the scenario that requires a clear understanding of the refresh process.

How to Manually Refresh in Power BI Desktop

When you're actively building a report in Power BI Desktop, you'll constantly need to pull in the latest data to make sure your charts and calculations are correct. A manual refresh is a quick, one-click process.

Follow these simple steps:

1. Open your .pbix file in Power BI Desktop.
2. Navigate to the Home tab on the top ribbon.
3. In the Queries section, a little to the right of the center, you'll see a large button labeled Refresh with a green circular arrow icon.
4. Click it.

That's it. Power BI will now connect to every data source you've set up in the Power Query Editor, re-run all the transformation steps you've applied, and load the fresh data into your in-memory data model. You’ll see a small window showing the refresh progress for each table. Once it's done, your visuals will automatically update.

Remember, this only updates your local file. To get these changes to your team, you need to save and re-publish the report to 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

How to Set Up a Scheduled Refresh in Power BI Service

Manually refreshing and republishing every day isn't efficient. The real power of Power BI comes from automating this process so your stakeholders always have the most current data. You do this by setting up a scheduled refresh in the Power BI service.

Before you start, there's one critical component you may need: an On-Premises Data Gateway.

When Do You Need a Data Gateway?

A Power BI Data Gateway acts as a secure bridge. It allows the Power BI Service (in Microsoft's cloud) to safely connect to data sources that live on a private network within your company (on-premises).

You need a gateway if your data sources are:

• Excel or CSV files on a local machine or network drive.
• An internal SQL Server database.
• Any other data source located behind your company's firewall.

You do not need a gateway if all your data sources are already in the cloud, like SharePoint Online, Azure SQL Database, or Google Analytics.

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

Step-by-Step: Setting Up Your Scheduled Refresh

Once you've published your report from Desktop to the Power BI Service, you can set it to refresh automatically.

1. Find Your Dataset

In the Power BI Service, navigate to the workspace where you published your report. In the list, you'll see both the report and the dataset. They usually have the same name. Find the dataset (it has a different icon than the report), click the three-dot menu (...), and select Settings.

2. Configure Data Source Credentials

Before Power BI can refresh your data, it needs permission to access the source. In the dataset settings, expand the Data source credentials section. Each data source in your report will be listed. Click Edit credentials for each one.

You'll need to provide the necessary login details (e.g., username/password for a database or an OAuth2 login for a cloud service). This is a secure one-time setup that allows the Power BI service to connect on your behalf.

3. Set Up the Gateway Connection (If Needed)

If you're using data sources that live on-premises, you'll need to link your dataset to your gateway. Under the Gateway connection section, you should see your configured gateway. You’ll just need to map your Power BI data sources to the corresponding sources you already set up in the gateway.

4. Configure the Schedule

This is where you tell Power BI exactly when to refresh. Scroll down to the Scheduled refresh section and toggle it On. You'll see several options:

• Refresh frequency: Choose either Daily or Weekly.
• Time zone: Select the correct time zone for your refresh schedule.
• Time: Click "Add another time" to specify the exact time of day you want the refresh to run. With a Power BI Pro license, you can schedule up to 8 automated refreshes per day. With Power BI Premium, you can schedule up to 48.

It's a good practice to also configure Refresh failure notifications. This way, if something goes wrong (like a password expiring), Power BI will immediately email you or the dataset owner to let you know.

5. Apply Your Changes

Once you are happy with the schedule, click Apply at the bottom of the screen. Your automated refresh is now live!

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

Performing an On-Demand Refresh in Power BI Service

What if a big sale just closed or fresh data was just uploaded, and you can’t wait for the next scheduled refresh to see it? Power BI lets you trigger a manual refresh right from the service.

Simply navigate to your workspace, find the dataset or the report in the list, and click the Refresh now icon (the same circular arrow). Power BI will queue the job and refresh all the data as soon as possible.

Troubleshooting Common Refresh Failures

Sometimes, refreshes fail. It happens to everyone. Here are some of the most common errors and how to fix them.

Problem: Expired or Invalid Credentials

• Error Message: "Failed to update data source credentials..."
• What it means: The password or authentication token Power BI uses to connect to your data source has expired or is no longer valid.
• How to fix: Go to your Dataset Settings > Data source credentials and re-enter your login information.

Problem: Gateway Is Offline

• Error Message: "The on-premises data gateway is offline or could not be reached."
• What it means: The physical machine where your gateway is installed might be turned off, asleep, or disconnected from the internet.
• How to fix: Ensure the computer is on and has an active internet connection. You may also need to check the gateway status in the on-premises gateway application on that machine itself.

Problem: Changes in the Data Source Structure

• Error Message: "The column '[Column Name]' of the table '[Table Name]' was not found."
• What it means: Someone renamed or deleted a column in your original data source (like in an Excel file or database table) that your Power BI report was using.
• How to fix: This error needs to be fixed in Power BI Desktop. Open the .pbix file, go to the Power Query Editor (Transform data), and refresh your queries there. The editor will show you exactly which step is causing the error. Either rename the column back, or update your query steps to work with the new structure, and then republish the report.

Final Thoughts

Keeping your Power BI dashboards updated is fundamental to reliable business reporting. Mastering the difference between a manual refresh in Desktop and setting up automated refresh schedules in the Service will ensure your team is always working with the most timely and accurate information available.

While Power BI is powerful for visualizing existing data, marketing and sales teams often struggle just to get all their data in one place to begin with - from Google Analytics, Facebook Ads, Shopify, Salesforce, and everywhere else. Our platform simplifies this entire process by connecting your data sources with a few clicks, providing automatically updating real-time dashboards so you never have to think about refresh schedules. You can just ask Graphed in plain English to build reports for you, turning hours of tedious setup into a 30-second conversation.