How to Refresh Data in Tableau

Working with a dashboard that has outdated information is like trying to navigate a new city with last year's map - it's frustrating and can lead you to the wrong conclusions. Keeping your data fresh is essential for making sound decisions. This guide will walk you through the various ways to refresh your data in Tableau, from manual updates in Tableau Desktop to fully automated schedules in Tableau Server and Tableau Cloud.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First Things First: Live Connection vs. Data Extract

Before jumping into specifics, it’s important to understand the two main ways Tableau connects to your data. The method you choose directly impacts how you'll handle refreshes.

1. Live Connection

A live connection queries your underlying database or source file directly. When you or a user interacts with a worksheet or dashboard, Tableau sends a query to the database and retrieves the latest results.

• Pros: Ideal for situations where real-time or near-real-time data is essential, such as monitoring critical operations.
• Cons: Performance depends entirely on the speed of your database. A slow database means a slow dashboard. Heavy usage can also put a significant strain on the source database.

2. Data Extract (.hyper file)

An extract is a static snapshot of your data that is ingested, compressed, and stored within Tableau. Instead of querying the live database every time, Tableau queries this high-performance, in-memory data file.

• Pros: Drastically improves dashboard performance, reduces the load on your core databases, and allows for offline data analysis.
• Cons: The data is only as fresh as the last refresh. You need a clear process to update it.

For most reporting scenarios, especially for dashboards shared with a wide audience, using an extract is the recommended best practice. Consequently, most of the focus on "refreshing" data in Tableau revolves around updating these extracts.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Refreshing Data in Tableau Desktop

Tableau Desktop is where you build most of your vizzes, making it the primary place for manual refreshes. This is perfect for when you're actively working on an analysis and need to pull in the latest numbers.

Manually Refreshing a Data Extract

If you're using a Tableau extract (.hyper), you can refresh it with just a few clicks. This action tells Tableau to go back to the original data source (like your database or Excel file), pull in all the latest information, and rebuild the extract file.

Here’s how to do it:

1. Navigate to any worksheet that uses the data source you want to update.
2. In the Data pane on the left, right-click on the data source.
3. Hover over Extract and then select Refresh from the context menu.

Tableau will ask if you want to perform a Full Refresh or an Incremental Refresh (if you've configured it).

• Full Refresh: This deletes the entire contents of the existing extract and replaces it with all the data from the source. It’s the most straightforward option.
• Incremental Refresh: This only adds new rows since the last refresh, based on a specific field like a Date or a sequential ID. It’s much faster for a large, constantly growing dataset (e.g., daily sales transactions).

Refreshing a Live Connection

If you have a live connection, "refreshing" simply means telling Tableau to re-query the database. This ensures the view you're looking at reflects the current state of the data source.

You can do this in a couple of ways:

• Click the "Refresh data source" icon (a circular arrow) in the toolbar at the top.
• Press the F5 key on your keyboard.
• Go to the main menu and select Data → [Your Data Source Name] → Refresh.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Automating Refreshes with Tableau Server and Tableau Cloud

Manually refreshing data every day isn't efficient, especially when you need to share up-to-date dashboards with your team. This is where automation through Tableau Server (your company's on-premise solution) or Tableau Cloud (the SaaS version from Tableau) becomes essential.

The core concept is to publish your data source or workbook to the server and then set a schedule for how often you want the extracts to be updated automatically.

Step 1: Publish the Data Source

Before you can automate anything, Tableau Server/Cloud needs to know how to connect to your data source on its own. To do this, you publish the data source from Tableau Desktop.

1. From your Tableau Desktop workbook, go to the Data Source tab.
2. Ensure you have created an Extract connection.
3. From the main menu, go to Server → Publish Data Source.
4. Follow the prompts to select the Project folder on your server and give your data source a name.
5. The most important step: Set the Authentication. For a scheduled refresh to work, you must select "Embed password" under Authentication. This securely stores the credentials, allowing the server to log in to your database to get new data without a person being there to type in a password.
6. Click Publish.

Step 2: Set Up a Refresh Schedule

Once your data source is living on Tableau Server or Cloud with a saved password, you can tell it when to refresh.

1. Log in to your Tableau Server or Tableau Cloud environment.
2. Navigate to the data source you just published.
3. Click the checkbox next to your data source.
4. Click Actions → Refresh Schedules...
5. A dialog will pop up where you can create a new schedule or attach to an existing one. Click New Extract Refresh.
6. You will see a list of pre-configured schedules (e.g., "Daily at 6 AM," "Hourly," "Weekly on Sunday"). These are created by your Tableau site administrator. Choose the schedule that fits your needs.
7. Click Create.

That's it! Tableau will now automatically handle refreshing your data extract on the schedule you set. Any workbooks connected to this published data source will automatically display the fresh data.

Best Practices and Troubleshooting

Keeping your data refreshes running smoothly is crucial. Here are a few tips to help you manage them effectively and fix them when they break.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Best Practices for Data Refreshes

• Use Extracts For Performance: If a dashboard is slow or widely used, switch to an extract. The performance boost is almost always worth setting up a refresh schedule.
• Choose Incremental Refreshes Wisely: For very large, transactional tables, using an incremental refresh can save significant time and system resources. Avoid it on data that might get updated retroactively.
• Stagger Your Schedules: Don't schedule every important extract to refresh at 9:00 AM on Monday. Spreading refreshes throughout off-peak hours (like overnight) reduces the load on your systems.
• Know About Tableau Bridge: If you use Tableau Cloud but your data is on-premise (e.g., on a SQL Server behind a corporate firewall), you'll need to use Tableau Bridge. It's a client that safely connects your private network data to your Tableau Cloud site, allowing for scheduled refreshes to occur.

Troubleshooting Common Refresh Failures

Sooner or later, you'll get a "Refresh Failed" email notification. Don't panic. The cause is usually one of a few common things:

• Database Credentials Have Expired: This is the number one culprit. If a database password was changed but not updated in the saved connection on Tableau Server, the refresh will fail. Simply edit the connection info and re-enter the new credentials.
• The Database Server is Down or Unreachable: Tableau can't refresh the data if it can't reach the database due to network issues or server maintenance. Check with your database administrator to see if there was an outage.
• The Source File Was Moved or Changed: If your data source is an Excel or CSV file on a network drive, and someone renames or moves it, the file path breaks, causing the refresh to fail. You'll need to update the workbook to point to the new location.

Final Thoughts

Mastering data refreshes - from the manual pull in Desktop to the automated schedule on a server - unlocks Tableau's full potential, turning static reports into living dashboards that drive timely action. Understanding the difference between live connections and extracts is the foundation, allowing you to choose the right strategy for speed and accuracy.

While Tableau is an incredibly powerful BI tool, connecting data sources and managing refresh schedules can involve technical setup and maintenance. We built Graphed because we believe getting insights shouldn't require that level of configuration. Our goal is to let you connect your marketing and sales data sources like Google Analytics, Shopify, or HubSpot with a few clicks, then build dashboards and get answers just by asking questions. Our platform keeps all your data live and up-to-date automatically, so you can focus on strategy instead of struggling with passwords, file paths, and refresh schedules.