How to Save Extract in Tableau
Working on a Tableau dashboard that takes forever to load can be incredibly frustrating. Fortunately, you can dramatically speed up slow dashboards and even work on your analysis offline by using a Tableau Extract. This guide breaks down what extracts are, why they're useful, and the exact steps to create and save them in your own projects.
What a Tableau Extract Is (and Why You Should Care)
In Tableau, you have two primary ways to connect to your data: Live and Extract.
- A Live Connection queries your source database directly every time you make a change to your dashboard - whether it's applying a filter, adding a new field, or drilling down into a chart. If your database is slow, busy, or has a shaky network connection, your dashboard will also be slow.
- An Extract Connection takes a different approach. It creates a snapshot of your data from the source and saves it as a highly compressed, optimized, and performance-tuned file right on your computer (or Tableau server). This file format is a
.hyperfile, and once it's created, all your interactions in Tableau will query this speedy local file instead of the original database.
Think of it like this: a Live Connection is like calling a restaurant every time you want to know what's on the menu. An Extract is like snapping a picture of the menu on your phone, so you can check it instantly whenever you want.
Switching from a live connection to an extract can provide some massive benefits for your analytics projects.
1. Incredible Performance Boosts
This is the number one reason people use extracts. Because Tableau isn't sending queries across a network to a potentially overloaded database, your dashboards become much faster. Interacting with filters, changing date ranges, and loading visualizations can go from taking minutes to mere seconds. Hyper extracts are engineered specifically for rapid analytical queries, allowing Tableau to answer your questions almost instantly.
2. The Ability to Work Offline
Since an extract is a self-contained, local file saved with your workbook, you can work on your analysis from anywhere. Whether you're on an airplane, at a coffee shop with spotty Wi-Fi, or just disconnected from your company's network, you can still open your Tableau workbook, build charts, and find insights without needing a direct line to your primary database.
3. Reduced Load on Your Databases
When you're running complex calculations and analysis in Tableau, you're putting a lot of demand on your data source. In a business setting, this can slow down critical operational databases used for production applications. By using an extract, you query that database just once to create the initial snapshot. All subsequent analytical heavy lifting happens right inside Tableau, giving your IT and database admin colleagues a much-appreciated break.
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.
4. Access to More Tableau Functionality
Certain Tableau features often work better or rely entirely on extracts. For example, functions like COUNTD (Count Distinct) can be significantly faster on an extract compared to a live connection to certain databases. Some data connectors are only supported via extracts, and using an extract unlocks the full suite of Tableau's data manipulation and calculation capabilities.
Step-by-Step Guide: How to Create and Save a Tableau Extract
Creating an extract is a simple process, and a few small adjustments in the settings can make a huge difference in performance. Follow these steps to get started.
Step 1: Connect to Your Data Source
Open Tableau Desktop and connect to your data just as you normally would. This could be anything from an Excel file, a CSV, a Google Sheet, or a corporate database like SQL Server or BigQuery.
For this example, let's connect to the "Sample - Superstore" dataset that comes built into Tableau.
Step 2: Switch to the "Extract" Connection Type
After connecting to your data, you'll land on the Data Source screen. Look in the upper-right corner of this page. You’ll see two options: Live and Extract. By default, Tableau usually selects "Live."
Your goal is simple: click the radio button to select Extract.
That's fundamentally all you need to do to tell Tableau you want to use an extract. You haven't created the file yet, but you've set your workbook's intention.
Step 3: Edit Your Extract Settings (Optional but Recommended)
Once you select "Extract," a link labeled "Edit..." will appear next to it. Clicking this opens the Extract settings dialog box. This is where you can fine-tune your extract for maximum efficiency.
Data Storage
You’ll see two primary storage options here: "Logical tables" and "Physical tables." For most users, sticking with the default "Logical tables" is the best choice. This setting creates a separate table inside your extract file that mirrors the logical tables in your data model, which is usually how you think about your data.
Filters
This is arguably the most powerful optimization feature. If your original data source contains billions of rows spanning a decade, but you only need to analyze the last two years of data, why pull all of it into your extract? An extract-level filter reduces the size of your extract file by only including the data that matters for your dashboard.
Click "Add..." to set up filters. For instance, you could add a date filter to only include data where [Order Date] is after January 1, 2022. This will significantly reduce the size of the extract and make every operation faster.
Aggregation
If you're building a high-level summary dashboard and don't need row-level detail, aggregation can be a huge help. This option lets you pre-summarize your data to the level of your chosen dimensions. For example, instead of storing every single sales transaction, you could aggregate the data to show "Total Sales per Month, per Region, per Category."
A word of caution: when you aggregate your data, you lose the ability to drill down to the more granular, underlying rows. Only use this if you're sure you won't need that level of detail.
Incremental Refresh
This setting is vital for large datasets that are frequently updated. A "Full Refresh" deletes the old extract and rebuilds it from scratch. An "Incremental Refresh" is smarter - it only queries and adds the new rows that have been added to your data source since the last refresh. You simply need to specify a column, like an Order ID or Create Date, that Tableau can use to identify the new rows.
Step 4: Generate and Save the Extract
After configuring your settings, the extract file isn't created immediately. Tableau waits until you need it.
Navigate to any worksheet (e.g., "Sheet 1"). At this point, Tableau knows you need data to build a visualization and will prompt you to save the extract file (.hyper). Give it a descriptive name and choose a location on your computer. After you click save, Tableau will query your source data, apply your filters and aggregations, and generate the final .hyper file.
With the extract saved, the little icon next to your data source in the "Data" pane will change from a single blue cylinder (for a live connection) to two cylinders with an arrow, indicating an extract.
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.
Keeping Your Data Fresh: Managing and Refreshing Extracts
An extract is a snapshot, meaning it won't automatically update when your source data changes. To keep your analysis relevant, you'll need to refresh it.
Manual Refresh in Tableau Desktop
The easiest way to update your extract is to right-click on your data source in the Data pane on the left side of your workspace. From the context menu, simply select Extract > Refresh. This will re-run the original query against your source database and overwrite the current extract file with the latest data.
Alternatively, you can go to the main "Data" menu, hover over your data source, and find the same Extract > Refresh option there. This menu also gives you the option to view the extract's refresh History or to Remove the extract completely, which would switch you back to a live connection.
Publishing and Scheduling Refreshes
Manually refreshing works fine for personal projects, but in a business context, this process needs to be automated. When you publish a workbook containing an extract to Tableau Cloud or Tableau Server, you can set it to refresh on a recurring schedule.
This automates the entire update process. You could schedule your sales extract to refresh every morning at 6 AM, ensuring that by the time your team logs on, they are looking at the previous day's numbers without anyone having to click a single button.
Final Thoughts
Using a Tableau Extract is a fundamental skill for anyone serious about building efficient, responsive dashboards. It gives you the power to transform sluggish, frustrating workbooks into fast, portable tools for analysis by creating an optimized, local snapshot of your data.
As you scale your reporting, you’ll find that creating and managing data pipelines for different platforms can quickly become as time-consuming as running the manual reports themselves. We created Graphed to cut through that complexity entirely. We connect seamlessly to your sales and marketing sources, like Google Analytics or Salesforce, and use simple, conversational language to build dashboards that are always live and up-to-date. This puts the focus back on strategy, not on managing manual data refreshes.
Related Articles
Facebook Ads for Pest Control: The Complete 2026 Strategy Guide
Learn how to run effective Facebook ads for pest control companies in 2026. This comprehensive guide covers campaign setup, targeting strategies, cost benchmarks, and best practices for generating quality leads.
Facebook Ads for Carpet Cleaners: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for carpet cleaning businesses in 2026. Get proven strategies for targeting, creative formats, retargeting, and budget that actually convert.
Facebook Ads For Personal Trainers: The Complete 2026 Strategy Guide
Learn how to effectively use Facebook ads for personal trainers in 2026. This comprehensive guide covers targeting strategies, ad creative, budgeting, and optimization techniques to help you grow your training business.