---
schema_version: "1"
id: c89fca33f758fed7ba8e1811cbc6c52d3dfd7538932636a22e3ea743fb58bf7f
title: Refresh Data Sources
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/public/desktop/refreshing_data.md
canonical_url: https://help.tableau.com/current/public/desktop/en-us/refreshing_data.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 989cade9a6b25b640ca8984e675aaa952df837fb3121d1ba1bf6916b66553a2a
description: Refresh live, extract, and published data sources in Tableau Desktop.
---
[Skip to main content](#main-content)

# Refresh Data Sources

If you are connected to a data source that has been modified, you can immediately update Tableau Desktop with the changes by selecting a data source on the Data menu and then selecting Refresh.

Not every connection will behave in the same way. There are three primary connection types: Live Connection, Extract, and Published Data Source. The type of connection is displayed by the icon next to your data source in the Data Pane.

### Live Connection

![Data source icon.](/tableau/current/en-us/public/desktop/en-us/Img/Menu_Ds.png)

A live connection sends queries to the database and updates the view depending on the results. However, the specific fields queried are defined when the connection is initially created. Refreshing the data source will update any new or changed fields. For more information, see [Connect to Your Data](https://help.tableau.com/current/public/desktop/en-us/basicconnectoverview.htm).

### Extract

![Data source extract icon.](/tableau/current/en-us/public/desktop/en-us/Img/Menu_Ds_Extract.png)

Refreshing an extract will query the data source the extract was created from and rebuild the extract. This process might take some time, depending upon the size of the extract.

### Published Data Source

![Tableau Cloud sparkle.](/tableau/current/en-us/public/desktop/en-us/Img/Online_Tableau_Sparkle.png)

When connected to a Published Data Source, the data source can be either a live connection or an extract. Selecting the Data Source tab will display whether the Published Data Source is a live connection or an extract. If the data source is an Extract, all refreshes of the extract are managed by Tableau Server and can only be refreshed by the server.

## Changes to underlying data

If a field that is used in a Tableau worksheet is removed from the underlying data of the data source and then the data source is refreshed, a warning message displays indicating that the field will be removed from the view and the worksheet will not display correctly because of the missing field.

If the underlying data changes—for example, if new fields or rows are added, data values or field names are changed, or data is deleted, Tableau will reflect those changes the next time you connect to the data source. However, because Tableau Desktop queries the data and does not import the data, you can immediately update Tableau to reflect the data modifications without disconnecting, provided the changes have been saved in the underlying data first.