Slow Extract Creation Query When Including MS SQL Server Geography Field

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


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


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


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.


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