How to Refresh Tableau Dashboard

Nothing is more frustrating than a dashboard displaying stale, outdated data. A great Tableau dashboard should provide a current, accurate view of your business, which means keeping the underlying data fresh is a top priority. This guide will walk you through exactly how to refresh your Tableau dashboards, from simple manual updates in Tableau Desktop to automated, scheduled refreshes in Tableau Server and Cloud.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First, Understand Live Connections vs. Extracts

Before you can refresh anything, you need to know how your dashboard is connected to its data. In Tableau, there are two primary connection types, and they handle refreshes differently.

Live Connections

A live connection queries your database directly. When you interact with a dashboard that has a live connection - by applying a filter, for example - Tableau sends a query to the database and displays the results. The data is as current as the data in the source system itself.

• When to use it: Use a live connection when you need up-to-the-second data latency, such as for monitoring a production line or tracking real-time stock prices.
• How it "refreshes": Refreshing a view with a live connection simply tells Tableau to clear its cache and requery the database. The true "refresh" happens at the database level.
• Downside: Performance depends entirely on the speed of your database. A complex dashboard connected live to a slow database will feel sluggish.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Data Extracts

A data extract is a snapshot of your data that's imported and stored in Tableau's optimized, in-memory database file format (a .hyper file). Your dashboard queries this local, high-performance file instead of the original database, which usually results in much faster performance.

• When to use it: Extracts are perfect for most analytics use cases where the data doesn't need to be live to the millisecond, such as daily sales reporting, monthly marketing performance, or quarterly financial analysis.
• How it refreshes: This is the process we most commonly refer to as "refreshing." It involves Tableau going back to the original data source (like SQL Server or a Google Sheet), pulling in new and updated data, and rebuilding the .hyper extract file.
• Upside: Significantly faster dashboard performance and less load on your primary database systems.

In short, if you are using a live connection, your data is already "live." If you are using an extract, you need to actively refresh it to see updated information.

How to Manually Refresh an Extract in Tableau Desktop

If you're working locally in Tableau Desktop and want to update your view with the latest data, you just need to perform a manual refresh of your data extract. This is a common workflow when developing a dashboard before publishing it.

There are a few ways to do this:

Method 1: Refresh from the Data Source Tab

1. Navigate to the Data Source tab in the bottom-left corner of your Tableau Desktop window.
2. In the top-right corner, you’ll see a summary of your data source. Click the circular arrow "Refresh" link next to the "Extract" text.
3. Tableau will connect to the original data source and rebuild your extract. This might take a few seconds or a few minutes, depending on the size of your data. The view will automatically update once it's done.

Method 2: Right-Click the Data Source

1. In the Data pane on the left side of any worksheet or dashboard, find the data source you want to update.
2. Right-click on the data source name.
3. In the context menu, go to Extract and then select Refresh. This will trigger the same rebuild process as Method 1.

Method 3: Using the Toolbar

If you're on a worksheet or dashboard, you can use the toolbar icon to trigger a refresh. Look for the icon with two circular arrows. It’s important to understand the different behaviors of this button:

• Clicking the button ("Refresh Data Source"): If you're using an extract, this command tells Tableau to re-query the local extract file, not the original data source. This is useful if multiple changes have been made in the workbook and you want to ensure the specific worksheet reflects the latest state of the local .hyper file.
• Using the dropdown (F5): Clicking the small dropdown arrow next to the refresh icon and selecting Refresh All Extracts serves as a shortcut to regenerate all data extracts in your workbook from their original sources, equivalent to Method 2. This is what you truly want when trying to get "new" data into the workbook.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Setting Up Automatic Refreshes in Tableau Server & Tableau Cloud

Manually refreshing in Tableau Desktop is fine for development, but the real power comes from publishing your dashboard and automating the process. By scheduling refreshes on Tableau Server or Tableau Cloud, you ensure that business users are always looking at current, reliable data without any manual intervention.

This is a two-step process: publishing the data source with the correct permissions, then setting the schedule.

Step 1: Publish the Data Source with Embedded Credentials

For Tableau Server to refresh an extract automatically, it needs to be able to access the underlying database on its own. It can't pop up a window and ask for a password when the job runs at 3 AM. This is why you must embed the database credentials during publishing.

1. In Tableau Desktop, with your workbook open, go to the top menu and select Server.
2. Click Publish Data Source and select the data source you want to automate.
3. The publish dialog will open. Choose the correct Project, give your data source a name, and add any tags or descriptions.
4. Here is the most important part: the Authentication settings. Click the "Edit" button. You will see several options:
5. Select "Embedded password," enter the login details for your database, and click Publish.

Step 2: Schedule the Extract Refresh

Once your data source is published with embedded credentials, you can set the recurring schedule.

1. Log in to your Tableau Server or Tableau Cloud account through your web browser.
2. Navigate to the project where you published your data source.
3. Find your published data source and click on it to open its details page.
4. Click on the Extract Refreshes (or "Refresh Schedules" in older versions) tab.
5. Click the New Extract Refresh button.
6. In the scheduling dialog, you'll see a list of predefined schedules created by your Tableau administrator (e.g., "Daily - 6 AM," "Hourly," "Weekly - Sunday Midnight"). Select the schedule that best fits your business needs.
7. Choose between a Full Refresh or an Incremental Refresh.
8. Click Create to save the schedule.

That's it! Your dashboard will now refresh automatically on the schedule you've set.

Troubleshooting Common Tableau Refresh Failures

Sometimes, scheduled refreshes fail. When this happens, Tableau will typically send an email notification to the data source owner. Here are the most common reasons and how to fix them.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

1. Authentication Errors

• The Problem: The refresh fails with a message like "Invalid username or password" or "Authentication failed."
• The Cause: The database password that was embedded has expired or was changed.
• The Solution: Navigate to the data source in Tableau Server/Cloud. In the top-right corner, click the "Actions" menu (...), select "Edit Connection," and enter the new, updated credentials. Rerun the failed refresh job to confirm it works.

2. Database or Network Errors

• The Problem: The error message mentions a "timeout," "cannot connect to the server," or "database error."
• The Cause: This could be a number of things. The database itself might be down for maintenance, or there could be a network connectivity issue between the Tableau Server machine and your database server (e.g., a firewall is blocking the connection).
• The Solution: First, confirm the database is online. If it is, contact your IT or database administrator. They will need to verify network paths and firewall rules to ensure the Tableau Server has a clear line of communication to the data source.

3. SQL/Permission Errors

• The Problem: The error points to a specific column being missing, or a table that doesn't exist, or permissions being denied.
• The Cause: Often, a change was made directly in the source database. A developer might have renamed a column that your dashboard depends on, or the permissions for the Tableau user account were tightened, and it can no longer read from that table.
• The Solution: Open the workbook in Tableau Desktop and try to refresh manually. Tableau will likely give you a more detailed error message. You'll need to work with the database owners to either get the necessary permissions restored or update your workbook to reflect the new structure of the database.

Final Thoughts

Keeping your Tableau dashboards fresh is a vital part of delivering reliable analytics. By understanding the difference between a live connection and a data extract, and by properly setting up published data sources with embedded credentials, you can automate your reporting and spend less time managing data and more time finding insights.

For many teams, the setup and maintenance of tools like Tableau, along with the management of data connections and refresh schedules, can turn into a full-time job. At Graphed, we remove that friction entirely. You can connect your marketing and sales data sources with a few clicks, and our platform handles the complex parts like pipelines and warehousing automatically. From there, you just ask questions in plain English to build real-time dashboards, leaving you free to focus on the answers your data holds, not the plumbing that gets it there.