KNOWLEDGE BASE

Error "Data Extract Required" Saving Workbook to Tableau Public


Published: 23 Feb 2016
Last Modified Date: 25 Sep 2017

Issue

When 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>

User-added image

Environment

  • Tableau Public
  • Tableau Desktop 
  • Live data connection for any data source other than Google Sheets

Resolution

For 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:

  1. Create an extract of the data source by clicking on 'Activate Data Extract' in the message displayed
User-added image
  1. Save the workbook to Tableau Public.
User-added image
 

Cause

Tableau 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 Information

The 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). 
Did this article resolve the issue?