How to Update a Table in Power BI

Ensuring your Power BI reports show the most current data is essential for accurate decision-making. If your tables are out of date, your entire analysis becomes unreliable. This guide will walk you through the various ways to update tables in Power BI, from a quick manual refresh in Power BI Desktop to automated, scheduled updates 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

Why Does Power BI Data Need to Be Updated?

Unlike some tools that query data live, Power BI's default behavior is to import and store a copy of your data within the PBIX file. Think of it as a snapshot taken at a specific moment in time. When the original data source – be it an Excel file, a Google Sheet, a SQL database, or a Shopify export – changes, Power BI doesn't automatically know about it. The snapshot it holds remains the same.

To see those changes in your dashboards and reports, you must perform a "refresh." A data refresh tells Power BI to go back to the original source, run the data transformation steps you defined in the Power Query Editor, and load the new, complete dataset into your model. This process ensures that your visuals accurately reflect the current state of your business.

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

Method 1: Performing a Manual Refresh in Power BI Desktop

The manual refresh is the most common method used while you are building and modifying your reports. It’s perfect for quickly pulling in recent changes from your data source to validate your work.

Refreshing All Tables at Once

This is the simplest way to update your entire report. It goes through every single data source connection in your file and updates them all.

1. Open your Power BI file (.pbix) in Power BI Desktop.
2. Navigate to the Home tab on the main ribbon at the top of the window.
3. Look for the large yellow Refresh button in the "Queries" section and click it.
4. A small window will appear, showing the status of each table as it connects to the source and loads the data. Once complete, the window will disappear, and the visuals in your report will update.

This is a quick and effective one-click solution, but be cautious with large data models. If your report connects to dozens of complex sources, refreshing everything at once can be time-consuming.

Refreshing a Single Specific Table

If you have a large report and only one of your tables has changed (for instance, a mapping table in an Excel file), you can save a lot of time by refreshing only that specific table. This is much more efficient than updating the entire model.

1. In Power BI Desktop, switch to either the Data View (the grid icon on the left pane) or the Model View (the diagram icon).
2. In the Data pane on the right-hand side, find the table you want to update.
3. Right-click on the table name (or click the three dots ... that appear when you hover over it).
4. Select Refresh data from the context menu.

Power BI will now refresh only that one table, skipping all the others. This process is significantly faster for reports with multiple data sources.

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

Method 2: Setting Up a Scheduled Refresh in Power BI Service

Once you’ve published your report for your team or stakeholders to view, you can’t rely on manually opening the file and clicking "Refresh" every day. This is where the Power BI Service comes in. It allows you to automate the refresh process on a schedule, ensuring your audience always sees up-to-date information.

Before you begin, ensure you have:

• Published your report to the Power BI Service (https://app.powerbi.com).
• A Power BI Pro or Premium license.
• A data gateway configured if your data is "on-premise," meaning it lives on a local computer or server (e.g., an Excel file on your C: drive or a local SQL server). The gateway acts as a secure bridge, letting the cloud-based Power BI Service access your local data.

Steps to Schedule an Automatic Refresh

1. Log in to your Power BI Service account.
2. In the navigation pane on the left, navigate to the Workspace where you published your report.
3. Hover over the dataset for your report (it often has the same name but with a different, orange icon) and click the three dots ... for "More options."
4. From the menu, select Settings.
5. First, expand the Data source credentials section. Click "Edit credentials" and make sure Power BI has the correct, secure access to your data source. This is usually done via an OAuth2 login for cloud sources.
6. Next, if you're using an on-premise source, expand the Gateway connection section and verify your gateway is mapped correctly and showing an "Online" status.
7. Finally, expand the Scheduled refresh section.
8. Toggle the switch next to "Keep your data up to date" to On.
9. Under Refresh frequency, choose either Daily or Weekly.
10. Set your desired Time zone.
11. Click Add another time to specify the times of day you want the refresh to run. With a Pro account, you can schedule up to 8 refreshes per day. With Premium, you get up to 48.
12. (Optional) Check the box to "Send refresh failure notifications to me" to receive an email if something goes wrong.
13. Click Apply to save your settings.

Your dataset will now refresh automatically according to the schedule you set, all without you having to lift a finger.

Method 3: Updating the Source of a Table

Sometimes, "updating" a table means more than just refreshing its data, it means changing where the data comes from entirely. Perhaps you moved an Excel file to a new SharePoint folder, or you need to switch from a test SQL database to the live production database.

This is easily done in the Power Query Editor without having to rebuild the table from scratch.

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 Change a Table’s Data Source

1. In Power BI Desktop, go to the Home tab and click Transform data. This will open the Power Query Editor.
2. In the Queries pane on the left, select the query (table) whose source you need to update.
3. On the right side of the screen, in the Applied Steps pane, find the first step, which is almost always named Source.
4. Click the small gear icon (⚙️) next to the "Source" step.
5. A dialog box will appear. Here, you can change the File path, Server name, URL, or anything else related to the connection. For example, you can browse for a new file location or enter a new database name.
6. After entering the new source information, click OK.
7. Power Query will attempt to connect to the new source. If successful, you’ll see the data preview update.
8. Click Close & Apply in the top-left corner to save your changes and load the data from the new source into your model.

Common Refresh Errors and How to Fix Them

Even with everything set up correctly, refreshes can sometimes fail. Here are a few common issues and their solutions:

• Credential Issues: The password for a data source may have expired. Solution: In the Power BI Service, go to Dataset settings, find your data source, and click "Edit credentials" to re-authenticate. In Desktop, go to File > Options and settings > Data source settings.
• Gateway is Offline: For on-premise sources, the machine running the gateway might be offline or has lost internet. Solution: Ensure the gateway machine is powered on and connected to the network. Restart the gateway service if necessary.
• Data Source Not Found: The file was moved, renamed, or deleted. Solution: Use the "Update the Source of a Table" method described above to point Power BI to the new location.
• Schema Mismatch: A column was renamed or removed in the source data. This will break any applied steps in Power Query that reference the old column name. Solution: Open the Power Query Editor. Find the step marked with an error (usually in red or yellow) and either remove that step or correct it to match the new column structure. For example, if you were sorting by a deleted column, you'll need to remove that "Sorted Rows" step.

Final Thoughts

Keeping your Power BI tables updated is a fundamental skill for anyone serious about data analysis. Whether you use a quick manual refresh during development or set up a dependable scheduled refresh for your published reports, understanding this process ensures your insights always reflect the latest reality.

While Power BI offers deep customization, we know that many marketing and sales teams need immediate insights without the complex setup and maintenance. We built Graphed to remove that friction. It connects to your data sources like Google Analytics, Shopify, and Salesforce in seconds, automatically keeping your data synced and delivering live dashboards. Simply ask a question in plain English, and Graphed creates the reports for you, so you can spend less time wrangling data and more time acting on it.