How to Save TDE in Tableau

Wrestling with slow, lagging dashboards in Tableau? Creating a Tableau Data Extract (TDE) is often the first and most effective step to speed things up and make your workbooks more portable. This guide will walk you through exactly what a TDE is, why you should use one, and how to create, save, and refresh it step-by-step.

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 Data Extract (TDE)?

A Tableau Data Extract, or a TDE file, is a compressed, local snapshot of your data. Instead of connecting directly to a "live" database every time you filter, sort, or interact with your dashboard, Tableau queries this lightning-fast local file on your computer. This dramatically improves performance, especially when working with massive datasets or slow database connections.

In modern versions of Tableau (10.5 and newer), the underlying technology was upgraded, and these files are now saved with a .hyper extension. While the technology is different (and even faster), the concept and the process of creating and using extracts remain the same. So, whether your organization still works with .tde files or the newer .hyper format, the principles in this guide apply.

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

Why Should You Bother with Data Extracts?

You might wonder why you wouldn't just use a live connection all the time. While live connections are great for viewing truly real-time data, extracts offer several massive advantages that make them the default choice for most analysts.

• Massive Performance Boost: Querying a local, optimized .hyper file is almost always faster than sending a query over a network to a remote database. If your dashboards take forever to load or update when you change a filter, an extract is your best friend.
• Offline Access: Because the data is saved on your computer, you can continue to build and analyze visualizations without being connected to the internet or your company's network. It's perfect for working on a flight, at a coffee shop, or from home.
• Reduced Load on Databases: Constantly querying a live production database can slow it down for everyone else who relies on it (like your sales team or your e-commerce site). Using an extract reduces the strain by only hitting the database once during a refresh, rather than with every click in your dashboard.
• Enhanced Functionality: Certain complex Tableau functions, like Count Distinct (COUNTD), can perform better or become available only after you create an extract, depending on your original data source.

How to Create and Save a TDE (or .hyper) File: A Step-by-Step Guide

Creating an extract is a straightforward process that you set up right after connecting to your data. Let's walk through it.

Step 1: Connect to Your Data Source

Start by opening Tableau and connecting to your data. This could be anything from an Excel file, a Google Sheet, or a cloud database like Amazon Redshift or Snowflake.

Step 2: Choose the "Extract" Connection Option

Once you connect and bring your tables onto the canvas, look at the top-right corner of the Data Source page. You'll see two radio buttons: Live and Extract. By default, Tableau might select "Live."

Click on Extract. This tells Tableau you don't want to query the live data source directly, instead, you want to create that local snapshot we've been talking about.

Step 3: Edit Your Extract Properties (Optional but Recommended)

After selecting "Extract," you'll see a link appear that says "Edit." Clicking this opens the Extract Data dialog box, where you can apply filters and aggregations to make your extract smaller and even faster.

• Add Filters: This is incredibly useful for reducing the extract size. If you only need to analyze sales data from the last two years, you can add a filter on the date field to exclude everything older. Why pull 10 years of data if you only need two?
• Aggregate Data: You can choose to "Aggregate data for visible dimensions." For example, if your transactional data has multiple records per day but you only ever report on daily totals, you can aggregate it to that level, significantly shrinking the file size.

Once you've set your preferences, click OK.

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 4: Go to a Worksheet to Generate the Extract

Here’s a crucial point: the extract file is not created until you need to use the data. To trigger its creation, simply navigate away from the Data Source tab and open a worksheet (e.g., "Sheet 1").

Tableau will now process the data and prompt you with a "Save As" window to save your data extract file. Choose a location on your computer, give it a name, and notice the file type will be "Tableau Hyper Extract (.hyper)" or "Tableau Data Extract (.tde)" depending on your version. Click Save.

That's it! Tableau will create the file, and you'll see a notice that the extract has been created successfully. Now all your work in this Tableau workbook will be running off this new, super-fast file.

.TDE vs .TWBX: How to Share Your Workbook Correctly

This is a common point of confusion for new Tableau users. You've saved your extract, but how do you share your dashboard with a colleague?

Understanding the File Types

• Tableau Workbook (.twb): This file contains the "instructions" for your dashboards - the layout, formatting, calculations, and colors. If you used an extract, the .twb file points to the .tde or .hyper file saved separately on your computer. If you email just the .twb file to someone, they won't be able to open it because they don't have the data extract file.
• Tableau Packaged Workbook (.twbx): This is an all-in-one package. Think of it like a zip file. It bundles the workbook instructions (the .twb), the data extract file (the .tde/.hyper), and any custom images or geocoding you used.

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

When to Save as a .twbx

Anytime you need to share your workbook with someone who cannot access your local file system or the original live database, you must save it as a Tableau Packaged Workbook (.twbx).

To do this, simply go to File > Save As... and in the "Save as type" dropdown menu, select "Tableau Packaged Workbook (*.twbx)". Now you have a single, self-contained file you can safely email or upload for others to use.

How to Keep Your Extract Data Up-to-Date

Your extract is a snapshot in time. To see the latest data, you need to refresh it. There are a few ways to do this.

• Full Refresh: The simplest method. In a worksheet, right-click your data source in the "Data" pane on the left. Go to Extract > Refresh. This will reconnect to the original data source and rebuild the entire extract from scratch with the latest data.
• Incremental Refresh: A more advanced but far more efficient option for very large datasets. You can configure this to only add new rows since the last refresh. This requires a column in your data that Tableau can use to identify new rows, like a transaction date or a sequential ID. To set this up, right-click the data source, select "Extract Data...", and under "Number of rows," choose "Incremental refresh."
• Scheduled Refreshes: For fully automated reporting, you can publish your data source and workbooks to Tableau Server or Tableau Cloud. There, you can set a schedule (e.g., every morning at 6 AM) for your extract to refresh automatically, ensuring your dashboards are always current without any manual effort.

Final Thoughts

Mastering Tableau Data Extracts is a foundational skill for any serious Tableau user. It unlocks faster performance, allows for offline work, and makes sharing your data visualizations much easier. By understanding when to use an extract and how to save your workbooks in the correct format, you can build more efficient and effective dashboards.

While Tableau extracts are powerful, managing connections, setting up reports, and remembering to refresh them can still consume valuable time. At Graphed, we automate this entire process. We allow you to connect all your data sources just once and then use simple natural language - like "show me monthly sales by product category" - to instantly create live, real-time dashboards that never need manual refreshing. It lets you skip the busywork of data prep and go straight to getting the insights you need.