KNOWLEDGE BASE

Error "Connectionless Failure" Refreshing Extract or Workbook


Published: 02 May 2014
Last Modified Date: 30 Dec 2016

Issue

When you try to refresh a workbook on Tableau Online or refresh an extract on Tableau Server, the following error might occur:
 
Connectionless Failure

Environment

  • Tableau Server
  • Tableau Online
  • Extracts

Resolution

Step 1 (Tableau Online only)

Verify that Tableau Online supports scheduled refreshes for your data source. See Additional Information below for the list of data source types.

Step 2: Recreate the extract

  1. In Tableau Desktop, open the extract.
  2. Select Data > New Data Source, and then create a live connection to the data source from which the extract was created.
  3. Recreate or copy all calculated fields that exist in the extract into the live data connection. For steps, see Additional Information below.
  4. Create an extract of the live connection.
  5. Replace the original extract with the new extract.
  6. Refresh the extract in Tableau Desktop.

Step 3: Republish and refresh the extract

  1. Republish the workbook to Tableau Online or Tableau Server, overwriting the previously published extract.
  2. Refresh the extract.

Additional Information

On Tableau Online, you can schedule refresh tasks for the following data source types:

  • MySQL, Microsoft SQL Server, and PostgreSQL data hosted with a cloud data provider such as Amazon RDS or Microsoft Azure.
  • Salesforce
  • Amazon Redshift
  • Google Analytics
  • Google BigQuery
  • Data you maintain inside your firewall that is linked to Tableau Online via the sync application.
For more information, see Scheduling Refreshes for On-Premises Data.

Copy and paste calculated fields

  1. Right-click or control-click the field in the Data pane, and then select Copy.
  2. In the new workbook, right-click or control-click in the Data pane, and then select Paste.
Did this article resolve the issue?