How to Schedule Data Refresh in Tableau Desktop

Nothing's more frustrating than making a business decision based on a report, only to find out the data was a week old. Keeping your Tableau dashboards updated ensures your insights are timely and relevant, but manually refreshing them every morning is a tedious chore. This guide will show you exactly how to automate that process by scheduling data refreshes in Tableau.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding the Two Types of Data Connections

Before diving into scheduling, it’s crucial to understand how Tableau connects to your data. There are two primary methods: Live connections and Extracts. Your choice here determines whether you even need to schedule a refresh.

Live Connection

A live connection queries your source database directly. Every time you interact with your dashboard - changing a filter, drilling down on a data point - Tableau sends a query to the database and retrieves the latest information.

• Pros: The data is always in real-time. There's no need to schedule updates because you're always looking at the most current information available in the database.
• Cons: Performance can be slow. If your database is large or the queries are complex, your dashboard can become sluggish and frustrating to use as it waits for the database to respond.

Data Extract (.hyper)

A data extract is a compressed snapshot of your data that is stored locally within Tableau. When you create an extract, Tableau queries your database once, pulls all the data, and saves it in a highly optimized file with a .hyper extension. From then on, all your dashboard interactions are blazing fast because Tableau is querying this local file, not the remote database.

• Pros: Incredible performance. Dashboards load quickly and user interactions are instant, even with massive datasets. It also reduces the load on your source database.
• Cons: The data becomes static. Since it's a snapshot, it will not update unless you manually refresh it or - more importantly - schedule an automatic refresh.

For most use cases, especially with large datasets or for dashboards that are viewed frequently by many users, data extracts are the way to go. This means you’ll need a way to keep that snapshot fresh, which brings us to scheduling.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Critical Detail: Tableau Desktop Itself Cannot Schedule Refreshes

This is the single most important concept to grasp and a common point of confusion for new users. You cannot schedule a recurring data refresh directly within the Tableau Desktop application.

Think about why this is the case. Tableau Desktop is a program installed on your personal computer. For a schedule to run automatically at 3 AM, your computer would need to be on, logged in, and running Tableau at that exact moment. It’s simply not practical or reliable.

Instead, scheduling is a server-side feature. To automate your data refreshes, you need to publish your work to one of Tableau's server environments:

• Tableau Cloud (formerly Tableau Online): Tableau's fully-hosted cloud solution.
• Tableau Server: A self-hosted version you manage on your own servers or private cloud.

The workflow is always the same: you create your data extract in Tableau Desktop, publish it to Tableau Cloud or Server, and then set up the refresh schedule there.

Step-by-Step: How to Schedule a Data Refresh in Tableau Cloud or Server

Ready to automate? Follow these steps to set up your first scheduled refresh. The process involves preparing your data in Desktop and configuring the schedule in your server environment.

Step 1: Create a Data Extract in Tableau Desktop

First, make sure your workbook is configured to use a data extract.

1. In your Tableau workbook, navigate to the Data Source tab in the bottom-left corner.
2. In the upper-right corner of the pane, under "Connection," select the Extract radio button.
3. Tableau might prompt you to save the extract file. If not, the extract will be created when you save the workbook or navigate to a sheet.
4. Once you've selected 'Extract', a link will appear to "Edit" the extract settings. Here you can add filters to reduce the size of the extract or choose how you want to aggregate the data. For now, the default settings are fine.

Now your workbook is powered by a high-performance .hyper extract instead of a live connection.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Publish the Data Source to Tableau Server or Cloud

Next, you'll publish your extract to the server, where it can be scheduled for refreshes.

1. With your workbook open, go to the menu bar and select Server > Publish Data Source. You'll be prompted to sign in to your Tableau Server or Cloud site if you haven't already.
2. Select your data source from the list (if you have multiple).
3. The "Publish Data Source" dialog box will appear. Here's how to configure the important settings:
4. Click Publish.

Your data extract now lives on the server, ready to be scheduled and used across multiple workbooks.

Step 3: Set The Refresh Schedule

With the data source published, you can now log in to your Tableau Cloud or Server site to set the schedule.

1. Using your web browser, log in to your Tableau Server or Cloud account.
2. Navigate to the project where you published your data source and click on its name.
3. Click on the Refresh Schedules tab.
4. Click the New Refresh Schedule button.
5. In the dialog box, you'll see a list of predefined schedules created by your server administrator (e.g., "Daily Morning Refresh," "Hourly," "Weekly on Sundays").
6. Select the schedule that fits your needs (e.g., daily at 6 AM).
7. Choose a Full Refresh. An incremental refresh is more advanced and requires a specific date/ID column to know which new rows to pull. For most cases, a full refresh is standard.
8. Click Create Schedule.

That's it! Your data source is now scheduled to refresh automatically. You can view the status of past and upcoming refreshes on this same page under the "Refresh History" tab, which is invaluable for troubleshooting.

Troubleshooting Common Refresh Failures

Sometimes, scheduled refreshes fail. It happens to everyone. Here are the three most common culprits and how to fix them:

• Problem: Invalid Credentials. This is the most frequent issue. The database password you embedded may have expired or been changed.
• Problem: Database Unreachable. The Tableau Server/Cloud couldn't connect and locate the database. This is common when your data source is private (on-premise).
• Problem: Data Source Structure Changed. A refresh can fail if the original data source's schema has been modified, for example, if a column that the extract relies on has been renamed or deleted entirely.

The Command-Line Workaround (For Advanced Users)

What if you don't have access to Tableau Server or Cloud? While you cannot set a recurring schedule, there is a way to script a refresh from Tableau Desktop using the Command Line Interface (CLI).

This method involves using a utility like Windows Task Scheduler or Cron on macOS to run a command that tells Tableau Desktop to open a workbook and refresh its extracts. It's not a real server-based solution, but it can get the job done when absolutely needed for yourself.

Here’s the basic command:

"C:\Program Files\Tableau\Tableau <Version>\bin\tableau.com" -refresh -workbook "C:\My Workbooks\Sales.twbx"

You can save this as a script and schedule it, but remember: the computer must be on and connected to whatever server the workbook extracts require for this command to successfully execute and can't always produce a guaranteed data refresh if your computer is on sleep mode, or updating when on.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Final Thoughts

Automating your data refreshes is a defining step in moving from casual data visualization to dynamic, reliable business intelligence. While Tableau Desktop itself is for creation and analysis, publishing an extract to Tableau Cloud or Server is the key that unlocks powerful, hands-free automation. This simple process eliminates manual work and ensures that you and your team are always making decisions with the freshest data available.

Although platforms like Tableau provide powerful scheduling capabilities, it can't always take time just to consolidate all the data we collect onto a data warehousing service, maintain those connections in Tableau, and build all the reports for said teams. This is a common situation for a majority of small businesses with little or zero engineers on staff so this isn't possible from day-to-day work lives. That's exactly why we built Graphed. The AI Analyst can help integrate one-click solutions within a few seconds so that teams who rely on platforms like Salesforce and Shopify for critical real-time insight have access now. By just using natural language prompts, you can generate powerful real-time live-updating reporting and visuals and never suffer any longer manually.