KNOWLEDGE BASE

Changing the File Path for Extracts


Published: 08 Mar 2014
Last Modified Date: 04 Apr 2023

Question

How to change the location of an extract data file in Tableau Desktop.

Environment

  • Tableau Desktop
  • Extract

Answer

  1. If you have a .twbx file, convert the .twbx file to a .twb file using one of the following methods:
    • In Tableau Desktop, open the packaged workbook (.twbx file), and then select File > Save As. Under Save as type, select Tableau Workbook (*.twb).
    • In Windows Explorer, right-click the .twbx file, and then select Unpackage.
  2. In Tableau Desktop, open the .twb file. Click the sheet tab and  then select Data > <data source name> > Extract > Remove.
  3. Select Just remove the extract, and then click OK.
  4. Select  Data > <data source name> > Extract Data, and then click Extract.
  5. Select the desired location, and then click Save.

Note: If you have an extract only data source, return to the data source tab and recreate the data source, choosing a new save location.

Additional Information

Whether or not you are prompted to specify the location for an extract depends on several factors.
  • If the workbook is a .twb (unpackaged workbook) connected to an extract (.tde), any changes to the extract will be saved to the location specified when the original extract was created. If you refresh or re-create the extract without removing the previous extract, you will not be asked to specify a new file location. If you remove the extract and then create a new extract, you will be prompted to select a file location for the extract.
  • If the workbook is a .twbx (packaged workbook) connected to an extract, any changes to the extract will be saved to the Tableau temp folder. Removing the extract and creating a new extract will not prompt you to select a file path. To work around this limitation, you must first convert the .twbx file to a .twb file.
To view these steps in action, see the video below.
Note: The video has no sound.




 
Did this article resolve the issue?