How to Update Tableau Data Source

Sooner or later, your data is going to move. Whether you're graduating from a test database to a production environment, switching from an Excel file to a SQL server, or simply updating a file path, keeping your Tableau workbooks connected to the right data is a core skill. This guide will walk you through exactly how to update, edit, and replace your data sources in Tableau, from simple refreshes to more complex swaps.

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

First, Which Kind of "Update" Do You Need?

The term "update" can mean a few different things in Tableau, each with its own process. Understanding the difference will save you a lot of headaches.

• Refreshing an Extract: This means you're pulling the latest data from the same data source you're already connected to. Your underlying file or database hasn't changed location or structure. You just want the newest rows of data.
• Editing a Connection: This is for when the location or login details of your data source have changed. For example, your database server moved to a new address, or the folder containing your CSV file was renamed.
• Replacing a Data Source: This is the most involved process. You're completely swapping one data source for another, like moving from that trusty old spreadsheet to a dedicated database or merging several messy sources into one clean one.

We'll tackle each of these scenarios step-by-step.

How to Refresh a Tableau Data Extract

A data extract (.hyper file) is a snapshot of your data, stored locally on your machine or on Tableau Server/Cloud. This makes your dashboards run much faster. Refreshing an extract updates this snapshot with the latest information from the original live data source.

In Tableau Desktop

This is the most direct way to get fresh data while you're building a workbook.

1. On any worksheet or dashboard, find your data source in the "Data" pane on the top left.
2. Right-click on the data source name.
3. Go to Extract > Refresh.

Tableau will reconnect to the original data source and pull in any new or changed data. This might take a few moments depending on the size of your data set.

Full vs. Incremental Refresh

When you set up an extract, Tableau gives you two options for refreshing it:

• Full Refresh: This replaces all the data in your extract with the data from the source. It’s simple and foolproof but can be slow for very large data sets.
• Incremental Refresh: This only adds the new rows of data. To use this, you need a column in your data that uniquely identifies new rows, like a timestamp or an ID number. This is much faster and more efficient for large, constantly growing tables.

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

Scheduling Refreshes on Tableau Server or Tableau Cloud

The real power of Tableau comes alive when your dashboards update themselves automatically. You can schedule your data extracts to refresh on a regular basis (hourly, daily, weekly) through Tableau Server or Tableau Cloud.

When you publish your workbook, you’ll be given the option to set up a refresh schedule. This means your stakeholders will always see the most current data without you ever needing to manually open Tableau Desktop and click "Refresh" again.

How to Edit a Data Source Connection

Sometimes your data's address changes. A server is renamed, a file is moved to a shared drive, or database credentials are updated. You don’t need to replace the data source, you just need to tell Tableau where to find it now.

Here’s how to do it:

1. Navigate to the Data Source tab in the bottom-left corner of Tableau Desktop.
2. You'll see your current connection in the top-left area. Right-click the data source connection (e.g., the name of your Excel file or SQL Server).
3. Select Edit Connection.
4. A dialog box will appear. Here you can change the details:
5. Click OK or Sign In to confirm the changes. Tableau will attempt to connect to the new details. If everything is correct, your data pane will update, and you're good to go.

Pro Tip: A common issue here is getting authentication errors. Double-check that you have the right username, password, and server details. IT teams often change these things, so it’s always good to confirm!

How to Replace a Tableau Data Source

This is the big one. Replacing a data source is necessary when you're fundamentally changing where the data comes from. Common reasons include:

• Migrating from a development database to a production database.
• Upgrading from a simple CSV or Excel workbook to a more scalable database like SQL Server or BigQuery.
• Switching to a new, cleaned, and prepped data source after a major data warehousing project.

The goal is to swap the old source for the new one without breaking all the charts, calculations, and dashboards you've worked so hard on.

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 Guide to Replacing a Data Source

Follow these steps carefully for a smooth transition.

1. Connect to the New Data Source

First, you need to add the new data source to your workbook. Keep the old one there for now.

• In Tableau Desktop, go to Data > New Data Source.
• Connect to your new database, file, or source just as you normally would. You'll now see both the old and new data sources listed in the "Data" pane.

2. Initiate the Replacement

Now, tell Tableau you want to perform the swap.

• Go to any worksheet in your workbook.
• Click on Data > Replace Data Source in the top menu.
• A dialog box will appear. For "Current", select your old data source. For "Replacement", select your new data source.
• Click OK.

At this point, Tableau will try its best to automatically map the fields from the old source to the new source. It does this by matching field names. This is where you might run into some issues.

3. Fix Broken Fields and Invalid References

After the replacement, you might see a sea of red. Don't panic! This is normal if the old and new data sources aren't identical.

Look for red exclamation points next to fields in the "Data" pane or for "red pills" in your views. These indicate that Tableau doesn’t know how to map a field from the old source to the new one.

To fix a broken field:

1. Right-click on the broken field (the one with the red exclamation point).
2. Select Replace References.
3. In the list that appears, find and select the correct corresponding field from your new data source.

You'll need to do this for every broken field. Once fixed, all the views in your workbook that used that field will automatically update.

4. Recreate Calculated Fields, Groups, and Hierarchies

Custom calculated fields, groups, sets, and hierarchies built on the old data source do not automatically transfer over. You’ll have to move them yourself.

• For calculated fields: The easiest way is to right-click the old calculation, choose "Edit," copy the formula, then create a new calculated field in the new data source and paste the formula in.
• For groups, sets, and hierarchies: Unfortunately, these often need to be rebuilt from scratch on the new data source. It's a manual process, but it ensures accuracy.

5. Close the Old Data Source

Once you’ve gone through your worksheets and dashboards and confirmed that everything is working correctly with the new data source, it's time to remove the old one.

• In the "Data" pane, right-click on the old data source.
• Select Close.

This removes the old source from your workbook entirely. Be sure to save your work!

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

Tips for a Pain-Free Replacement

• Standardize Your Field Names: This is the single most important tip. Before you even start the replacement process in Tableau, if you have control over the new data source, try to make the column names identical to those in the old source. If Sales Amt in your old Excel file becomes SalesAmount in the new database, Tableau won't map it. Matching them beforehand saves almost all the post-swap clean-up work.
• Check Your Data Types: Ensure that corresponding fields have the same data type. A Customer ID that is a Number in one source and a String in another can cause issues with calculations and joins.
• Back Up Your Workbook: Always, always, always save a backup copy (a .twbx file) of your workbook before you attempt a major data source replacement. If something goes wrong, you can easily go back to the original version.
• Start Small: Test the replacement on a single, simple worksheet first. This helps you identify any major mapping issues before they ripple through dozens of complex dashboards. Go sheet by sheet confirming everything is right.

Final Thoughts

Updating your data sources in Tableau, whether you're refreshing an extract, editing a connection, or completing a full replacement, is a common task that keeps your analysis accurate and trustworthy. By following a methodical process and preparing your data sources for a smooth handover, you can keep your dashboards live and avoid the frustration of broken visualizations.

Of course, manually managing and updating data sources can become a tedious part of the job, especially when you have data spread across multiple platforms like Google Analytics, Shopify, and Salesforce. We believe getting insights shouldn't get bogged down in technical chores. At Graphed, we've automated this process entirely. You connect your data sources to our platform just once, and we handle the live connections and refreshes for good. Instead of fixing broken fields in Tableau, you can use Graphed to ask questions in plain English like "Create a dashboard showing Facebook Ads spend vs. Shopify revenue by campaign," and you'll get an interactive, real-time dashboard instantly, always connected to your latest data.