Last Modified Date: 17 Jan 2019
- Tableau Desktop
- Excel files
- Text files (.csv, .txt)
- Packaged workbook (.twbx)
ResolutionOption 1: Edit the connection to point to the original data source
If saving the work as a *.twbx file, extract the connection to the text file first. If the connection to the text file should be live, then always save the workbook as a *.twb file.
- In Tableau Desktop, select Data > <data source name> > Edit Data Source. This will navigate to the Data Source tab for this data source.
- Select Data > <data source name> > Edit Connection...
- Note: The file path will include the TableauTemp folder rather than the original location of the file
- In Windows Explorer, navigate to the original data source file, and then click Open.
- In Tableau Desktop, click the Extract radio button
- Navigate to any worksheet tab in the workbook, which will prompt Tableau Desktop to create the extract
- To refresh data, under Data, right-click the data source, and then select Extract > Refresh.
Option 3: Create a new connection to replace the old connection
- Click Data at the top toolbar, and select New Data Source > Excel
- Select the correct file, and connect. This will create a second connection to the same file.
- Navigate to any sheet that uses the old data connection.
- Replace the old connection with the new connection. For detailed directions, see Replace Data Sources
CauseThis behavior is by design to allow workbooks to be shared with users that do not have access to the original data source. Please see Packaged Workbooks for more information:
"Packaged workbooks contain the workbook along with a copy of any local file data sources and background images. The workbook is no longer linked to the original data sources and images."If the original data source is a text file, then Tableau Desktop will create a shadow copy of the text file in the TableauTemp folder. If the connection to the text file is live, then Tableau Desktop will change the file path to the TableauTemp folder.
- Note: this change will not show until the workbook is saved, closed, and reopened.
Additional InformationIf the file path in Option 1 > Step 2 is not pointing to TableauTemp, then there may be another underlying issues. For other possible scenarios, please see the Related Links section of this article.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials