How to Refresh Extract in Tableau Server

Keeping your dashboards powered by fresh data is a non-negotiable for making sound business decisions. If you're using Tableau Server, that often means refreshing your extracts. This guide will walk you through exactly what Tableau extracts are, why they need refreshing, and the step-by-step process for setting up both manual and automated refreshes on Tableau Server.

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, What Exactly is a Tableau Extract?

Before diving into the "how," let's quickly cover the "what." A Tableau Extract is a saved snapshot of your data that gets imported and optimized for Tableau's data engine. Think of it as a highly compressed, local copy of your original data source. This is different from a "live" connection, which queries your database directly every time you interact with a dashboard.

There are a few key reasons why you'd use an extract (.tde or the newer, faster .hyper format) instead of a live connection:

• Performance: Extracts are almost always faster. Since the data is stored in Tableau's optimized format, visualizations load much quicker, especially with large datasets or complex calculations.
• Reduce Database Load: By using an extract, you're not constantly hitting your production database with queries. This is a huge relief for your database administrators and applications that rely on that database.
• Offline Access: If you publish a workbook with an extract, users can download and interact with it offline using Tableau Reader or Tableau Desktop without needing access to the original data source.
• Data Portability: Sharing a workbook with a packaged extract (.twbx) is easy because all the necessary data is bundled inside the file.

The only catch? Since an extract is a snapshot in time, it will become outdated as your source data changes. That's where refreshing comes in.

Why Bother Refreshing an Extract?

Imagine your sales team is reviewing a dashboard to track their quarterly performance, but the data is from three weeks ago. That dashboard isn't just unhelpful, it's actively misleading. Stale data leads to bad assumptions, missed opportunities, and poor decisions.

Refreshing an extract updates that static snapshot with the latest and greatest information from the original data source. It's the essential process that keeps your data relevant and your dashboards trustworthy. Consistent refreshes ensure everyone from marketing analysts to the CEO is looking at the most current picture of the business.

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

How to Manually Refresh an Extract in Tableau Server

Sometimes you can't wait for the next scheduled refresh. Maybe a big marketing campaign just ended, or you fixed an error in the source data and need to see the update immediately. For these situations, a manual refresh is your go-to solution.

1. Navigate to Your Workbook or Data Source

Log in to your Tableau Server environment. Browse through your projects to find either the workbook or the published data source you want to refresh. It’s often best practice to refresh the published data source directly, as this will update all connected workbooks at once.

2. Find the "Refresh Extracts" Option

Once you've located the content, click the three-dot icon (…) to open the Actions menu. From this menu, you’ll see an option labeled Refresh Extracts.

3. Choose a Full or Partial Refresh

After clicking "Refresh Extracts," a dialog box will appear. You'll typically be given a choice to perform a full refresh. This option completely replaces the existing data in the extract with the fresh data from the source. Some setups also allow for an incremental refresh, which we'll cover more in the next section.

Select "Full Refresh" and click the "Refresh" button (sometimes labeled "Run Now") to start the process.

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

4. Monitor the Refresh Job

Just because you clicked the button doesn't mean it's done. Tableau Server queues this request as a "job." To check its status, navigate to the Jobs section on the left-hand navigation panel of Tableau Server. Here, you can see all background tasks, including your extract refresh. You can filter by task type to see just "Extract Refreshes."

You can see if the job is in progress, successfully completed, or if it failed. If it fails, Tableau will often provide an error message that can point you toward the root cause.

Setting Up a Scheduled Extract Refresh (The "Set It and Forget It" Method)

Manually refreshing works in a pinch, but for most business-critical dashboards, you'll want to automate it. Setting up a schedule ensures your data is updated reliably and consistently without any manual intervention. This is how you get daily reports to actually update daily.

1. Prerequisite: Embed Your Credentials

This is the most critical and often-missed step. For Tableau Server to automatically refresh an extract, it needs to be able to access the original data source on its own, without you being there to log in. This means you must embed the database credentials into the data source connection when you publish it from Tableau Desktop.

When publishing, under "Authentication," choose the option for Embedded password. This securely stores the login information on Tableau Server, allowing it to authenticate on your behalf when a scheduled refresh runs.

2. Navigate to the Data Source on Tableau Server

Log in to Tableau Server and locate the published data source you wish to put on a schedule. Click on its name to go to its main page.

3. Go to the "Extract Refreshes" Tab

On the data source's page, look for a tab called Extract Refreshes (it might be labeled as "Scheduled Tasks" in older versions). This is your command center for all things automation for this particular data source.

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

4. Create a New Refresh Schedule

Click the New Extract Refresh button. This will open a new dialog where you can configure the refresh.

5. Configure the Schedule Details

In this window, you'll set the rules for your automated refresh:

• Schedule: You'll see a dropdown of available schedules. These schedules (e.g., "Daily at 6 AM," "Hourly," "Weekly on Mondays at Midnight") are created and managed by your Tableau Server Administrator. Select the one that fits your business needs.
• Refresh Type: Full vs. Incremental.
• Error Notifications: You can choose to be emailed if the refresh fails. This is highly recommended so you can proactively fix any issues. You can have it notify the data source owner or other specific users.

6. Create the Schedule

Once you’ve configured everything, click "Create." And that's it! Your data source is now scheduled to refresh automatically. You'll see your newly created task listed under the Extract Refreshes tab, where you can also see the last refresh time and what the next one is scheduled for.

Troubleshooting Common Refresh Failures

Scheduled refreshes are great until they fail. Here are some of the most common reasons your extracts aren't refreshing, and how to fix them:

• Credential Errors: This is the number one culprit. The password embedded in the connection has expired or been changed. Solution: Navigate to the data source settings, edit the connection, and re-enter and embed the correct password.
• Database or Network Unreachable: Tableau Server couldn't connect to the database. This could be due to a firewall, the database server being offline for maintenance, or other network issues. Solution: Check with your IT team or database administrator to ensure the server has a clear path to the data source.
• Query Timeout: The data query took too long to run, and Tableau Server canceled it to free up resources. Solution: Try to optimize the underlying query or view in your database. If possible, switch to an incremental refresh. As a last resort, you can ask your Server Administrator to increase the query timeout limit for the server.
• Incorrect File Path (for flat files): If your data source is an Excel or CSV file on a network share, the server needs a full UNC path (e.g., \\fileserver\Marketing\reports\data.csv), not a mapped drive letter (like Z:\reports\data.csv). Solution: Edit the data source connection and provide the full, correct UNC path to the file.

Final Thoughts

Learning how to refresh extracts is a fundamental skill for keeping your analytics environment humming. Whether you're running ad-hoc manual updates or setting up reliable automated schedules, this process is what transforms your dashboards from static reports into dynamic decision-making tools. By ensuring your data is fresh, you empower your team to operate with confidence and clarity.

While mastering scheduled refreshes in Tableau is valuable, teams often find themselves managing dozens of data sources and reports, turning data management into a full-time job. This is why we built Graphed Our platform connects to all your marketing and sales tools and lets you build real-time dashboards just by asking in plain English. No more dealing with extract schedules or credential errors - your data is always live, and you can get answers in seconds, not hours.