---
schema_version: "1"
id: 1b7af5045fdc6c444118229fe4b5de7db83d4cccda242e52ea6d5412d7871c10
title: Refresh Data Sources
collection: tableau
version: next
locale: en-us
portal_url: https://docs.salesforce.com/tableau/next/en-us/public/desktop/refreshing_data.md
canonical_url: https://help.tableau.com/v0.0/public/desktop/en-us/refreshing_data.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 0254e5a589e2881b60b4aa31ade22f491beb2d4810a29ea069e4fc7d91bff8e6
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/next/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/v0.0/public/desktop/en-us/basicconnectoverview.htm).

### Extract

![Data source extract icon.](/tableau/next/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/next/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.