How to Update Tableau Dashboard with New Data

You’ve built a great Tableau dashboard, but its value drops quickly if the data is stale. Keeping your visualizations updated is essential for making timely, accurate decisions. This guide covers the fundamentals of keeping your dashboards fresh, walking you through manual updates in Tableau Desktop and setting up automated refreshes on Tableau Server or Tableau Cloud.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding How Tableau Handles Data Freshness

Before you update anything, it’s helpful to understand the two primary ways Tableau connects to your data: Live Connections and Extracts. The method you choose fundamentally changes how updates work.

Live Connections

A live connection queries your database directly. When you or a user interacts with a dashboard that has a live connection, Tableau sends a query to the source database and retrieves the latest results. This means the data is always as current as the underlying data source.

• Pros: Ideal for situations where real-time data is a must, like monitoring operational metrics.
• Cons: Performance can be slow if the source database is large or not optimized for fast queries. Heavy dashboard usage can also put a significant strain on your database.

Data Extracts (.tde or .hyper)

A data extract is a compressed snapshot of your data that is stored and optimized for Tableau. Instead of querying the live database every time, Tableau queries this local, high-performance file. This usually results in much faster dashboard performance.

• Pros: Significantly faster performance, reduces the load on your source database, and enables offline data analysis.
• Cons: The data is only as fresh as the last time the extract was refreshed. You need to create a process to update it.

Most performance-focused or large enterprise dashboards use extracts. Therefore, the rest of this guide will focus on how to keep those extracts updated, a process known as "refreshing."

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Manually Refreshing Data in Tableau Desktop

Manually refreshing an extract is a simple process you'll perform within your Tableau Desktop application. This is perfect for when you are actively building a dashboard or need an immediate, one-off update before a presentation.

Step-by-Step Guide to a Manual Refresh

Follow these quick steps to update your data source snapshot.

1. Open Your Workbook: Launch Tableau Desktop and open the workbook connected to the data source you want to update.
2. Navigate to a Worksheet: Go to any worksheet that uses the data source.
3. Locate the Data Source: In the 'Data' pane on the top left, find the data source you need to refresh.
4. Right-Click and Refresh: Right-click on the data source's name. A context menu will appear. Select 'Refresh'. Tableau will then connect to the original data source (your Excel file, SQL database, etc.) and rebuild the extract with the latest information.

You can also perform a full refresh from the 'Data' menu at the top of the application by selecting your data source and then clicking 'Refresh'.

When to Use a Manual Refresh

A manual refresh is practical for ad-hoc analysis or development work. For example, if your marketing team just updated a Google Sheet with new campaign performance numbers from this morning, a quick manual refresh allows you to immediately see that new data in your development workbook. However, relying on this method for regular operational reporting is inefficient and prone to human error.

Method 2: Automating Refreshes with Tableau Server or Tableau Cloud

For any dashboard that your team relies on for regular business decisions, automation is the answer. By publishing your data source and dashboard to Tableau Server or Tableau Cloud, you can schedule automatic refreshes to run daily, hourly, or on any custom schedule you need, ensuring your stakeholders always have access to current information without any manual intervention.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Prerequisites for Scheduled Refreshes

Before you can automate, there are a few things you need to have in place:

• Tableau Server or Cloud Access: You need to be a Publisher on a Tableau Server or Tableau Cloud site.
• Published Data Source: It's a best practice to publish your data source separately from the workbook. This allows multiple workbooks to use the same centrally-managed, refreshed data source.
• Embedded Credentials: When you publish the data source, you'll need to embed the database credentials. This allows Tableau Server to connect to your database on its own to perform the refresh without needing you to log in.

Setting Up a Refresh Schedule

Once your data source is published, scheduling the refresh is straightforward.

1. Navigate to Your Data Source: Log in to your Tableau Server or Tableau Cloud account. Navigate to the project where your data source is published and click on it.
2. Go to the 'Extract Refreshes' Tab: On the data source's page, you’ll see several tabs like 'Connections' and 'Connected Workbooks'. Click on the 'Extract Refreshes' tab.
3. Create a New Refresh Schedule: Click the 'New Extract Refresh' button. A dialog box will appear, letting you configure the refresh.
4. Configure the Schedule: You will see a list of pre-defined schedules set up by your Tableau administrator (e.g., "Daily at 6 AM", "Hourly"). Choose the one that best fits your needs. You can choose the type of refresh (full or incremental) and what happens if the refresh fails.
5. Create the Schedule: Once you've selected your options, click 'Create'. That's it! Tableau will now automatically refresh your extract according to the schedule you selected.

Full vs. Incremental Refreshes

When you set up an automated schedule, Tableau lets you decide between two options that define how much data you’re retrieving once it's set up:

• A full refresh replaces all the rows every time with fresh data to provide a comprehensive update. They ensure every record is up-to-date and account for changes in historical figures. This is the simplest option but can take longer and may put an unnecessarily large amount of strain on the server at high volumes.
• An incremental refresh uses a select column from your data set — often a date or ID field — to check for rows that are newer than what was previously fetched in your last update. This is much faster since it's a smaller subset of rows to download, making it easier on any server you might self-host.

Common Refresh Issues and How to Troubleshoot Them

Scheduled data refreshes are a game-changer, but sometimes they fail. When that happens, Tableau administrators and data source owners usually receive an alert email. Here are a few common causes and how to investigate them.

1. Connection Issues or Expired Credentials

This is by far the most common refresh failure point. Your data source password may have expired, or the user permissions might have been changed.

• Solution: Go back to your data source on Tableau Server or Tableau Cloud and navigate to the 'Connection' tab of your data source. You’ll have an option to ‘Edit connection’ that will guide you through entering the password and any other necessary information or prompts your server requires.

2. The Source File Was Moved or Path is Now Invalid

If you're connected to a document that lives locally, like a CSV, Excel, or flat file, it might just need its new location refreshed as well so Tableau knows where to point the queries.

• Solution: In cases like this, re-publish the workbook or the data layer so Tableau can reorient itself from within Tableau Desktop. You can always replace the file using the original name on a shared folder your Server already accesses if you don't want to make changes. This will still point the queries in your data model correctly just as before and requires making fewer adjustments for your dashboard(s).

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. Database Errors Preventing Queries from Running

Server-side issues for self-hosted databases often come up as a cause when failures like this occur or become too common. Whether tables are moved, column types changed, or there is an unexpected error, any changes or outage on that end of operations is likely to cause issues for your reporting workflow so check there first by running SELECT *.

• Solution: Your first step in a database error should be contacting the owner you might be working with to test and figure things out together or get assistance so you can keep everything updated properly. Once you and a DA or another engineer from your team can find the query causing this kind of problem in logs from your Tableau Server, it's most likely due to a syntax mismatch or other issues in this layer making reports for your entire company. You can trace it back to its root source so you'll be able to fix this in a manner best for any business.

Final Thoughts

Keeping your Tableau dashboards updated is a crucial part of delivering continued value from your data visualizations. By understanding the difference between live connections and extracts, you can handle immediate updates with manual refreshes in Tableau Desktop and implement reliable, automated schedules on Tableau Server and Cloud for long-term consistency.

For organizations looking to sidestep the complexities of server management and refresh schedules entirely, modern tools are changing the game. With features such as out-of-the-box native data integrations, we created Graphed to completely remove the need for technical dashboards, creating a product where data stays live entirely, automatically syncing for instant views of company performances. There’s no need to manage an entire process or workflow as our systems do this all for you - getting answers and making important decisions at all stages quicker because it helps to create more speed at the same time, making any team instantly smarter, all on their own and for each other.