Error "Data Extract Required" Saving Workbook to Tableau Public
Published: 23 Feb 2016
Last Modified Date: 25 Sep 2017
IssueWhen saving a workbook to Tableau Public, the following message occurs:
Data Extract Required
The Tableau server you are publishing to does not permit external database connections. Use the Data menu to create an extract for the following data source:<data-source-name>
- Tableau Public
- Tableau Desktop
- Live data connection for any data source other than Google Sheets
ResolutionFor a workbook that uses a live connection to a supported data source, you must create an extract in Tableau Desktop before you can publish the workbook to Tableau Public.
* With the exception of Google Sheets, an extract is always necessary to publish to Tableau Public
Follow these steps:
- Create an extract of the data source by clicking on 'Activate Data Extract' in the message displayed
- Save the workbook to Tableau Public.
CauseTableau Desktop Public Edition and Tableau Public (web) work with data from Microsoft Excel, Microsoft Access, multiple text file formats, statistical files, and web data connectors.
Additional InformationThe Tableau Desktop Public Edition does not display this error message. This is because Tableau Desktop Public automatically saves an extract (.tde) of the data source as a temporary file when publishing the workbook to Tableau Public on the web (as a .twbx).