Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Delete a Data Source in Tableau

Cody Schneider••8 min read

Removing a data source in Tableau should be a simple click, but it often leads to a cascade of broken worksheets and dashboards. If you've ever deleted a data source only to see your hard work covered in red error messages, you know how frustrating it can be. This tutorial will walk you through the correct, foolproof method to safely delete or replace a data source in Tableau without breaking anything.

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 Would You Need to Delete a Data Source?

Before diving into the "how," let's quickly cover the "why." You might find yourself needing to remove a data source for several common reasons:

  • Upgrading Your Data: Perhaps you started your analysis with a simple Excel or CSV file. Now, you’ve moved to a more robust, centralized data source like a SQL database, a cloud data warehouse like BigQuery, or an official API connection. You'll need to swap the old file for the new, live data source.
  • Data Source Consolidation: Your workbook might have multiple versions of the same data or similar data sources that have been consolidated into one primary source. Cleaning out old or duplicate sources keeps your project tidy and efficient.
  • Changing Connection Types: You may decide to switch from a live connection to a Tableau Extract (.hyper file) to improve dashboard performance. Alternatively, you might need to switch from an extract back to a live connection to get real-time data.
  • Removing Irrelevant Data: As projects evolve, certain data may become obsolete. Removing unused or irrelevant data sources simplifies your workbook and makes it easier for other team members to understand and maintain.
  • Correcting Errors: You might have initially connected to a data source with incorrect tables, joins, or data preparation steps. Deleting the faulty source and starting fresh is often the cleanest solution.

The Golden Rule: Replace First, Delete Second

Here’s the most important concept to understand: never delete a data source that is currently being used by any of your worksheets. Tableau links every chart, filter, and calculated field to a specific data source. When you pull the plug by hitting "Close" on that source, Tableau loses the reference for every field used in your visuals. This is what causes dashboards to break.

The correct approach is to not just delete the old source, but to seamlessly replace it with the new one. Tableau has a brilliant built-in feature called "Replace Data Source" that automatically remaps all your fields and calculations from the old source to the new one. Once the swap is complete and you've confirmed everything is working, you can safely remove the original source. Think of it like swapping out a car's engine while the car is still running - you carefully connect the new engine before disconnecting the old one.

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.

Step-by-Step Guide to Safely Deleting a Data Source

Let's walk through the process, using the scenario of replacing an old Excel file named "Sales Data - Q1.xlsx" with a new, updated file named "Sales Data - Official.xlsx".

Step 1: Get Prepared

First, make sure both your old and new data sources are present in the Tableau workbook. Go to any worksheet. In the top-left corner, you'll see the "Data" pane, which lists all the data sources connected to your workbook. A small blue checkmark indicates the primary data source for the current sheet.

If your new data source isn't already connected, add it now. Click the small cylinder icon with a plus sign (Add New Data Source) or navigate to Data > New Data Source from the top menu. Connect to your new file or database.

After adding it, you should see both the old source ("Sales Data - Q1") and the new source ("Sales Data - Official") in your Data pane.

Step 2: Use the "Replace Data Source" Feature

This is where the magic happens. We'll tell Tableau to replace the old source with the new one.

  1. From the top menu, go to Data > Replace Data Source...
  2. A small dialog box will pop up.
  3. Under Current:, make sure your old data source ("Sales Data - Q1") is selected.
  4. Under Replacement:, select your new data source ("Sales Data - Official").
  5. Click OK.

Tableau will now attempt to remap everything automatically. It does this by matching field names. If a field named "Revenue" exists in both data sources, Tableau will seamlessly transfer all references to the new one. Behind the scenes, Tableau replaces the original data source with the new one across all worksheets where it was in use. After doing this, you'll notice that the old source ("Sales Data - Q1") has an icon showing it is no longer the primary source for any sheet.

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

Step 3: Hunt Down and Fix Broken Fields

Sometimes, the transition isn't perfect, especially if there are inconsistencies in field names between the two sources. If Tableau can't find a matching field name in the new source, it will mark the old field as "broken."

Look in the Data pane under your new data source. Do you see any field names with a small red exclamation point (!) next to them? These are your broken fields.

This is extremely common if, for example, a field was called "Customer_ID" in the old file but is named "CustomerID" (without the underscore) in the new one.

Fixing them is easy:

  1. Find the broken field in the sidebar (e.g., "Customer_ID !").
  2. Right-click on it.
  3. Select "Replace References..."
  4. A list will appear showing the available fields from your new data source. Find and select the correct corresponding field (e.g., "CustomerID").
  5. Click OK.

The red exclamation point will disappear. Repeat this process for every broken field. Don't forget to check your calculated fields, as they may also break if they reference a field that has changed names. You may need to edit the calculation to use the new field name syntax.

Step 4: Verify Your Worksheets and Dashboards

Before you get rid of the old source for good, do a sanity check. Click through every single worksheet and dashboard that used the old data connection. Check for the following:

  • Do all visualizations render correctly?
  • Are the numbers and values what you expect?
  • Are all your filters, parameters, and tooltips working as intended?

This QA step is crucial. It’s much easier to fix an issue now while you still have both data sources available for comparison. Take five minutes to confirm everything is perfect.

Step 5: Safely Close the Old Data Source

Once you’ve replaced the source, fixed any broken fields, and verified your dashboards, you can finally part ways with the old data source. It's now just sitting in your workbook, unused.

  1. Go back to the Data pane in any worksheet.
  2. Find the old, unused data source ("Sales Data - Q1").
  3. Right-click on it and select Close.

And that's it! The old source disappears. When you save your workbook, it will be gone for good, leaving you with a clean, updated Tableau project that uses your new data source flawlessly.

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.

What If a Data Source Isn't Used Anywhere?

The process above is for data sources actively in use by your visualizations. What if you just have an extra data source sitting in your workbook that you never ended up using? In this case, the process is much simpler because there's nothing to break.

You can identify an unused data source by checking if it appears as the primary source (with the blue checkmark) on any of your worksheets. If not, it's safe to remove directly.

Simply go to the Data pane, right-click the unused data source, and select Close. No replacement needed.

Final Thoughts

Deleting a data source in Tableau is all about being methodical. Blindly closing a connection is a recipe for disaster, but following the "replace, fix, verify, and then close" workflow ensures a smooth transition every single time. By using the built-in "Replace Data Source" feature, you let Tableau handle the heavy lifting, saving you from a frustrating game of fixing broken charts.

While managing connections in any BI tool can be tedious, it’s a standard chore in keeping our analytics up-to-date. At Graphed, we focus on helping you skip that manual setup work entirely. Instead of connecting data sources and building reports piece by piece, you can easily connect all your marketing and sales platforms (like Google Analytics, Salesforce, Facebook Ads, Shopify) and simply ask for the dashboards you need using natural language. This way, your reports are not only live and automatically updating but also require zero manual build time. We help teams move straight to insight, automating the repetitive data wrangling so you can get answers faster across all your platforms in Graphed.

Related Articles