KNOWLEDGE BASE

Difference in Render Time Between Published Datasource and Embedded Connection


Published: 28 Jun 2016
Last Modified Date: 16 Aug 2016

Issue

When using a published datasource, performance is quite slow; but when using an embedded datasource, Tableau Server performs as expected.

Environment

  • Tableau Server 9.2
  • Windows Server 2012
  • MS SQL Server

Resolution

Option 1

Upgrade to Tableau Server 10.0. For more information, see Upgrading Tableau Server

Option 2

If you are unable to upgrade, use the following workaround: 
  1. Open the workbook connected to the published datasource in Tableau Desktop.
  2. Make copies of the calculated fields that are in the published datasource.
  3. Use the copies rather than the original calculated fields.
When using the calculated field copy, the calculation lives in the workbook rather than in the published datasource, which changes the way the query is processed.

Cause

The way queries are processed when connected live or connected to a published data source is different.

 
Did this article resolve the issue?