How to Clear Tableau Cache

Cody Schneider8 min read

When your Tableau dashboard doesn't show the latest numbers, your first instinct is usually to blame the data source. While that’s sometimes the case, the issue often lies closer to home: in Tableau’s cache. This article explains what the cache is, why you'd want to clear it, and provides step-by-step instructions for clearing it in Tableau Desktop, Server, and Cloud.

GraphedGraphed

Still Building Reports Manually?

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

Watch Graphed demo video

Why Bother Clearing the Tableau Cache?

Tableau uses caching, a process of temporarily storing data and query results, to make your dashboards load faster. When you open a dashboard, Tableau checks if it has run the same queries or computations before. If it has, it pulls the data from its cache instead of going all the way back to the original data source. This significantly boosts performance, especially with large datasets or complex visualizations.

There are, however, a few key situations where this helpful feature can cause problems:

  • Stale Data: The most common issue. You know the underlying data in your database has been updated, but your dashboard is still showing the old information. The cache is serving you the old results.
  • Troubleshooting Errors: If a view is acting strangely - not rendering correctly or showing unexpected errors - clearing the cache can reset its state and resolve the problem.
  • Testing Data Source Changes: When you're making changes to your data connection, custom SQL, or relationships in the data model, you need to clear the cache to ensure you’re testing the new configuration from a clean slate.

Clearing the cache forces Tableau to ignore its saved results and run a fresh query against your live data source, ensuring you see the absolute latest information available.

First, Understand: Live Connection vs. Data Extract

Before you start digging into cache settings, it's vital to know whether you're working with a Live Connection or a Tableau Data Extract (.hyper file). The "stale data" problem is different for each.

  • Live Connection: When you use a live connection, Tableau sends queries directly to your database in real-time. Caching here means Tableau is storing the results of those queries to speed things up. Clearing the cache forces Tableau to re-query the database. This is the scenario most of this article focuses on.
  • Tableau Extract: An extract is a snapshot of your data that has been pulled from the source and stored in Tableau's optimized, high-performance format. If your data is stale, the problem might be that the extract itself needs to be refreshed, which is a separate process from clearing the cache. You would right-click the data source and select "Refresh Extract." Caching still exists on top of the extract, but refreshing the extract is the first step for outdated extract-based dashboards.

You can see your connection type in the top-left corner of the Data Source pane in Tableau Desktop or by looking at the data source details on Tableau Server.

GraphedGraphed

Still Building Reports Manually?

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

Watch Graphed demo video

Step-by-Step: Clearing the Cache in Tableau Desktop

For users building visualizations in Tableau's desktop application, there are several ways to clear the cache, ranging from a simple refresh to a manual deep clean.

Method 1: Hitting Refresh (The Easiest First Step)

The simplest way to bypass the cache for a view is to ask Tableau to refresh it.

  • Press the F5 Key: With your worksheet or dashboard open, simply pressing the F5 key on your keyboard is the quickest way to refresh the data source.
  • Click the Toolbar Icon: Alternatively, click the "Refresh" icon (a circular arrow) in the toolbar at the top of the window.

This action tells Tableau to re-run the queries for the current view, bypassing any cached query results for that specific worksheet. It's quick, easy, and often all you need.

Method 2: Re-open the Workbook

It sounds too simple, but it works. Much of the cache in Tableau Desktop is session-based. By saving your work, closing Tableau Desktop completely, and then reopening the workbook, you effectively flush the memory cache from the previous session. If a quick F5 refresh didn't work, this is your next best option.

Method 3: The Manual Deep Clean (When All Else Fails)

If you suspect something is truly "stuck" in the cache, especially with maps or custom visuals, you can manually delete Tableau's local cache files. This forces a complete reset.

Heads up: Before deleting anything, make sure Tableau Desktop is completely closed.

On Windows, Tableau stores its cache files here:

C:\Users\<your username>\AppData\Local\Tableau\Caching

On macOS, the location is a bit trickier to find but is usually within the ~Library/Caches/ directory.

Steps to Manually Clear the Desktop Cache:

  1. Close Tableau Desktop completely.
  2. Open File Explorer (Windows) or Finder (Mac).
  3. Navigate to the cache folder path listed above. Note: The AppData folder in Windows is hidden by default. You may need to enable "Show hidden items" in the View tab of File Explorer.
  4. Once inside the Caching folder, you can safely delete the contents. These are temporary files and will be regenerated by Tableau the next time it runs. To be safe, you might want to copy them to a backup folder first before deleting.
  5. Relaunch Tableau Desktop. It will start with a fresh cache.

This method is the most thorough and solves persistent issues tied to old, saved application state.

GraphedGraphed

Still Building Reports Manually?

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

Watch Graphed demo video

Clearing the Cache on Tableau Server & Tableau Cloud

Managing the cache on Tableau Server or its cloud-based version, Tableau Cloud, is a different experience. The controls are primarily in the hands of server and site administrators who balance performance against data freshness for hundreds or thousands of users.

Method 1: Forcing a Dashboard Refresh (For All Users)

If you're viewing a dashboard on Tableau Server and suspect the data is old, you can force a refresh yourself without needing admin rights.

  • Use the Refresh Button: Just like in Desktop, Tableau Server's interface has a "Refresh Data" icon (circular arrows). Clicking this tells the server to re-query the data source, bypassing its cache for your view.
  • Append the URL Parameter: A powerful trick is to add ?:refresh=y to the end of the dashboard's URL in your web browser. This forces the server to fetch fresh data from the source, no matter what the site's caching settings are.

For example: https://your-server.com/#/site/Marketing/views/SalesDashboard becomes https://your-server.com/#/site/Marketing/views/SalesDashboard?:refresh=y

Method 2: Configuring Data Connection Caching (For Admins)

Tableau Server administrators can configure how aggressively the server caches data for live connections across an entire site. This setting tells Tableau how long it should hold on to query results before considering them "stale."

You can find this setting under Settings > Data Connection Caching. The options are:

  • Refresh More Often: This setting keeps the cache for as brief a time as possible, defaulting to "As fast as possible." This provides the freshest data but increases the load on your database since more queries are run live.
  • Balanced: The default option. It tells Tableau to keep the cache for a specified duration, such as 30 minutes or an hour. It provides a good mix of performance and data freshness.
  • Refresh Less Often: This holds the cache for a long time (up to 12 hours), maximizing dashboard performance but at the cost of having less current data. This is useful for dashboards based on data that only updates once a day.

Choosing the right setting depends entirely on your business needs. Dashboards for operational monitoring need fresh data, while dashboards for weekly strategic reviews can afford a longer cache time.

GraphedGraphed

Still Building Reports Manually?

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

Watch Graphed demo video

Method 3: Clearing the Entire Server Cache with TSM (Server Admins Only)

For on-premise Tableau Server installations, administrators can use the Tableau Services Manager (TSM) command-line tool to clear the entire server's external query cache at once.

  1. Open the Command Prompt or Terminal as an administrator on the primary node of your Tableau Server installation.
  2. Log in to TSM with the command: tsm login
  3. Run the command to clear the cache: tsm data-access caching clear
  4. After the command finishes, apply the pending changes: tsm pending-changes apply

This is a powerful action that will affect all sites and users on the server, as it forces all subsequent dashboard loads to query the database directly until the cache is rebuilt. It's typically used during troubleshooting or after major data source or server maintenance.

Final Thoughts

Knowing how to clear Tableau's cache is a key troubleshooting skill that saves a lot of headaches. For Tableau Desktop, pressing F5 or restarting the application solves most issues, with manual folder deletion as a last resort. For Server and Cloud users, the ?:refresh=y URL trick is an invaluable tool for getting the latest data on demand.

Staying on top of data freshness and connectivity doesn't have to be a constant struggle with troubleshooting commands and confusing settings. At Graphed, we’ve built a platform that automates this entire process. You connect your data sources once, and we provide instantly live dashboards that are always up-to-date, so you never have to think about stale data, server configurations, or clearing a cache again. Just describe the dashboard you want in plain English, and get real-time insights without the technical overhead.

Related Articles

How to Enable Data Analysis in Excel

Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!