KNOWLEDGE BASE

Removing Data Source Connection Properties from Packaged Workbooks


Published: 13 Aug 2014
Last Modified Date: 02 Nov 2017

Question

How to remove data source connection properties from packaged workbooks.

Environment

Tableau Desktop

Answer

  1. Open the workbook and connect to the data source.
  2. Create an extract of the data source. For more information, see Extracting Data.
  3. Close the connection to the database. For more information, see Closing Data Sources.
  4. Connect to the Tableau Data Extract file. For more information, see Connect to Data.
  5. Save the workbook as a packaged workbook (.twbx). For more information, see Packaged Workbooks.

Additional Information

Workbooks retain connection information (servername, database name, username) in order to refresh data extracts. Creating an extract and then connecting to that .tde file will remove the connection information from the workbook.
Did this article resolve the issue?