How to Delete Tableau Extract

Removing a Tableau extract is a simple task, but knowing exactly which buttons to click and understanding the consequences is essential to avoid accidentally breaking your workbooks. This guide walks you through the steps for deleting extracts in both Tableau Desktop and Tableau Server/Cloud and explains why you’d want to do it in the first place.

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

What Exactly Is a Tableau Extract?

Before deleting one, let's quickly review what a Tableau extract is. When you connect to your data in Tableau, you have two primary options: a Live Connection or an Extract.

• A Live Connection queries the underlying database directly. Every time you filter, drill down, or update a visualization, Tableau sends a new query to the data source. This is great for real-time data but can be slow if the database is overloaded or your internet connection is poor.
• An Extract, on the other hand, is a compressed snapshot of your data that is saved locally as a .hyper file. Tableau then queries this high-performance file instead of the original database. This dramatically speeds up performance, allows for offline analysis, and reduces the load on your production databases.

In short, an extract is a saved, optimized copy of your data that makes your dashboards fast. But sometimes, these saved copies need to be managed or removed entirely.

Top Reasons to Delete a Tableau Extract

Deleting an extract isn't something you'll do every day, but there are several practical reasons why you might need to clean house. Understanding these motivations will help you decide if it's the right move for your situation.

1. Freeing Up Storage Space

Tableau extracts can be quite large, sometimes running into many gigabytes, especially if they contain millions of rows of data. If you have dozens of extracts published to Tableau Server or stored on your local machine, this can quickly consume valuable disk space. Deleting old, unused, or redundant extracts is a straightforward way to reclaim that space.

2. Troubleshooting Data Corruption or Connection Issues

Occasionally, an extract can become corrupted during a failed refresh. You might encounter strange errors, missing data, or performance issues that you can't explain. Deleting the existing extract and creating a new one from scratch is often the quickest and most effective way to resolve these types of glitches.

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

3. Switching Back to a Live Connection

You might initially create an extract for development purposes or for analyzing a static dataset. However, once a dashboard is ready for production, the business requirement may be to have real-time data. In this scenario, you'd want to remove the extract and switch the data source back to a live connection to ensure your visualizations always reflect the very latest information.

4. Sunsetting an Old Data Source

Databases get migrated, business systems change, and old data sources become obsolete. When you no longer need the data associated with a workbook or published data source, deleting the extract is a necessary step in retiring the asset and keeping your Tableau environment tidy.

5. Redesigning Your Data Model

Let's say you've made significant structural changes to your source database, like renaming columns, changing data types, or altering table relationships. Your existing extract will no longer match the new structure, which will cause refresh failures. Rather than trying to fix the mismatch, it's often easier to delete the old extract and generate a new one based on the updated data model.

How to Delete an Extract in Tableau Desktop

In Tableau Desktop, deleting an extract is a two-part process. First, you tell Tableau to stop using the extract file. Second, you physically delete the .hyper file from your computer.

Step 1: Switch from the Extract to a Live Connection

Start by opening your Tableau workbook (.twb or .twbx file).

1. Navigate to the Data Source tab, located in the bottom-left corner of the Tableau window.
2. In the top-right corner of the Data Source pane, you'll see the Connection options: Live and Extract. If an extract is currently in use, the "Extract" radio button will be selected.
3. To stop using the extract, simply select the Live radio button.

That's it! Tableau will immediately switch its connection method and begin querying the original database directly. At this point, the workbook is no longer dependent on the .hyper file stored on your machine. However, the file itself still exists.

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 2: Physically Delete the .hyper File (Optional)

If your goal is to save disk space, you’ll also want to remove the extract file from your computer's hard drive. Tableau often saves these files in your "My Tableau Repository" folder.

1. First, save your Tableau Workbook after switching to a live connection.
2. Find the location of your extract. If you don’t know where you saved it, you can find out by clicking on the Data menu, selecting your data source, and then choosing Extract → Properties. The path to the file will be listed there.
3. Navigate to that folder using Windows File Explorer or Mac Finder.
4. Locate the .hyper file and simply delete it just like any other file.

Important Note: Before you delete the file, be absolutely certain that no other workbooks are using it. If multiple workbooks are referencing the same extract, deleting it will break those other reports.

What About the "Remove Extract" Option?

If you right-click on your data source from a worksheet tab, you'll see an option to "Remove" the extract. This is different from deleting the physical file. This action tells the workbook to forget about the extract without actually touching the .hyper file on your disk. You’d use this if you want to create a brand new extract from the same data source without having to set up the connection details again.

How to Delete an Extract from Tableau Server or Tableau Cloud

The process for deleting an extract is different if it's part of a published data source on Tableau Server or Tableau Cloud. For this, you typically need to be a Project Leader, an Administrator, or have specific permissions for that data source.

Step 1: Locate the Published Data Source

Start by logging into your Tableau Server or Tableau Cloud environment.

1. Navigate to the Explore section and find the project that contains your published data source.
2. Filter the content to show only Data Sources.
3. Find the specific data source you want to delete in the list.

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: Check for Connected Workbooks

This is a critical safety step! Deleting a published data source that is actively being used will break all connected workbooks. Before deleting it, you must check its dependencies.

1. Click on the name of the data source to open its details page.
2. Navigate to the Connected Workbooks tab.
3. This will show you a list of every single workbook that relies on this data source.

If you see any workbooks listed here, you need to either edit them to use a different data source or accept that they will stop working once you proceed. Make sure to communicate with the workbook owners before deleting anything.

Step 3: Delete the Data Source

Once you’ve confirmed it's safe to proceed, you can delete the data source and its associated extract.

1. Go back to the list of data sources in your project.
2. Click the three-dot (...) menu next to the data source you want to remove.
3. From the dropdown menu, select Delete.
4. A final confirmation dialog will appear, warning you one last time about the potential impact. If you're sure, click Delete again.

Tableau will then remove the published data source from the server, and the stored .hyper extract file will be permanently deleted along with it. This action cannot be undone.

Best Practices and Final Tips

Removing data sources can be a bit stressful, but following a few simple guidelines can help prevent mistakes.

• Always Check Dependencies: We can't stress this enough. Before deleting any published data source on Tableau Server/Cloud, always check the "Connected Workbooks" tab. It’s the easiest way to avoid breaking a colleague's important dashboard.
• Communicate First: In a team environment, let people know before you delete shared resources. A quick message in your team’s Slack channel can save hours of confusion and troubleshooting later.
• Understand Refresh vs. Delete: Don't confuse deleting an extract with refreshing one. A refresh updates the existing extract with the latest data from the source. Deleting removes it completely. If you only want updated data, you should set up an extract refresh schedule, not delete the file.
• Backup First: Before making significant changes, it's always a good idea to download a backup of your workbook or data source from Tableau Server, just in case you need to restore it.

Final Thoughts

Whether you're working locally in Tableau Desktop or managing a shared environment on Tableau Server, deleting an extract is a core data management skill. The key is to understand whether you just need to switch to a live connection for real-time analysis or permanently remove a published data source to clean up your environment.

Managing extracts, refresh schedules, and data sources is often cited as one of the more tedious parts of using traditional BI tools. At Graphed, we’ve simplified this entire process. Instead of creating and babysitting extracts, you connect your data sources - like Google Analytics, Salesforce, or Shopify - one time. From there, our dashboards pull live, real-time data automatically. You can build reports just by asking questions in plain English, completely skipping the manual work of creating extracts, managing .hyper files, and scheduling refreshes.