KNOWLEDGE BASE

Performance Issues with Published Data Sources


Published: 15 May 2014
Last Modified Date: 19 Aug 2015

Issue

When working with published data sources, the following behaviors might occur:
  • Performance is degraded when working with large filters and sets.
  • Performance is degraded when data blending with one or more published data sources.

Environment

  • Tableau Desktop 8.3 and earlier versions
  • Tableau Server 8.3 and earlier versions
  • Published data source

Resolution

Option 1

Upgrade to Tableau Desktop and Tableau Server 9.0 or later. For more information, see Upgrading Tableau Desktop and Upgrading Tableau Server.

Option 2

Use the following workaround to extract data when data blending:
  1. Right-click on the Published Secondary Data Source and select Create Local Copy.
  2. Right-click on the local copy of the Published Secondary Data Source and select Extract Data.
  3. Select Extract.
  4. Select Data > Replace Data Source.
  5. In the Current: drop-down menu, select the published data source.
  6. In the Replacement: drop-down menu, select the new extracted data source.
  7. Click OK.

Option 3

Create a live connection to the data source from which the published data source was extracted.

 

Cause

Earlier versions of Tableau Server Data Server were unable to create temporary tables with a published data source. 
 

Additional Information

The following behaviors are known limitations resulting from the lack of temporary tables:
  • Performance may decrease with large filters and sets, as Tableau must perform a complex query to accomplish the task.
  • Performance may be degraded when data blending, as this feature typically uses temporary tables.
Did this article resolve the issue?