KNOWLEDGE BASE

Slow Extract Creation Query When Including MS SQL Server Geography Field


Published: 13 Mar 2019
Last Modified Date: 17 Apr 2019

Issue

Refreshing an extract from MSSQL that includes a Geography field takes longer than expected.

Environment

  • Tableau Desktop 2018.1 and later
  • MS SQL Server
  • Geography type fields

Resolution

As a workaround, bulk fetch can be turned off by using a TDC file to customize the connection. For more information about .tdc files, see Customize and Tune ODBC Connections > Create a .tdc file in Tableau Help. 

Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.

Cause

This is by design as a result of bulk fetch.
Did this article resolve the issue?