KNOWLEDGE BASE

"Data Extract Required" Message When Publishing to Tableau Online


Published: 28 May 2013
Last Modified Date: 20 Jun 2017

Issue

When you publish a workbook to Tableau Online, 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>

Environment

  • Tableau Online
  • Tableau Desktop
  • Live data connection

Resolution

For a workbook that uses a live connection to a data source type that is not listed below, you must create an extract in Tableau Desktop before you can publish the workbook to Tableau Online.

Follow these steps:

  1. Save extract as a .tds (Tableau Data Source) file.
  2. Publish the .tds file to Tableau Online.
  3. Connect to the published extract in Tableau Desktop.
  4. Publish the workbook to Tableau Online.

Cause

Tableau Online supports live connections only to data source types listed in Additional Information.

Additional Information

You can publish workbooks with live connections to the following data source types:
  • Google BigQuery
  • Amazon Redshift
  • MySQL, Microsoft SQL Server, and PostgreSQL data hosted with a cloud provider such as Amazon RDS or Microsoft Azure.
Did this article resolve the issue?