SQL Server Extract Refreshes More Slowly After Upgrading Workbook to 2018.1

KNOWLEDGE BASE

SQL Server Extract Refreshes More Slowly After Upgrading Workbook to 2018.1

Published: 27 Jul 2018
Last Modified Date: 02 Jan 2019

Issue

When upgrading a .twbx with embedded extracts created from SQL Server, the refresh is very slow to complete compared to the same extract in 10.5.

Environment

Tableau Desktop 2018.1 and newer versions
Microsoft SQL Server

Resolution

Edit the data source, and hide any new fields that have been brought in before refreshing the extract.

Cause

Tableau 2018.1 and newer versions recognize some SQL Server spatial data types which were not recognized by previous versions.
Although extracts created in Tableau 10.5 did not query for these fields, after the extract is upgraded to 2018.1 and refreshed, any of these spatial fields present in the data source will be brought into the extract. Querying for these additional fields can increase the extract's refresh time.