Last Modified Date: 18 Dec 2017
- Tableau Desktop
Option 1: From 10.2 and later versionsNew columns in Excel data can be successfully brought into the extract refresh if the refresh is done from the Data Source tab in Tableau Desktop. To do so, please follow the steps below:
- Click the Data menu in the Tableau Desktop navigation bar
- Select Refresh Data Source.
Option 2: For earlier versionsIf an extract is being used, and the Excel data source is modified with new columns, then you will need to remove the extract, connect to the original data source and create a new extract to reflect the new data structure. However there are also two workarounds which may help if the above is not an option:
- Right-click the extract and select "Edit Data Source". On the Data Source tab wait until the data updates with the new columns and switch back to the view - the new columns should now be added to the view.
- Connect to the data source (Excel spreadsheet) and create a new extract. Then right-click the original extract (the one that is missing the new columns), select "Replace data source" and replace the original extract with the newly-created extract. The original extract can then be removed from the view. For more information, see Replace Data Sources.
CauseWhen connecting to Excel directly from Tableau Desktop (earlier versions), Tableau will pull the new column from the Excel data source on refresh. However, if an extract is being used then new columns will not be imported upon refresh - only new rows will be added for columns which are already part of the extract. The extract structure would have to be updated to receive any new columns.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials