When Connecting to Azure SQL Server Using Extract Text is Unexpectedly Truncated

Published: 11 Mar 2022
Last Modified Date: 13 Mar 2022


When connecting to Azure SQL server using an Extract, text is unexpectedly truncated.

Originally : 29601 character
Truncated : 16383 character

When connecting to DB with Live.
User-added image

When connecting to DB with Extract.
User-added image


  • Tableau Desktop 2021.4.2
  • Microsoft Azure SQL Server ver12.0.2000.8


1. Create a tdc file like the following.
<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='azure_sqldb' enabled='true' version='10.5'>
    <vendor name='azure_sqldb' />
    <driver name='azure_sqldb' />
        <customization name='CAP_ODBC_BIND_FORCE_MAX_STRING_BUFFERS' value='yes' />

2. Store the tdc file in the following folder.
C:\Users\<user_name>\Documents\My Tableau Repository\Datasources

3. Restart tableau desktop and connect to the data source with the extract.


By design, memory limit has been reached.
Did this article resolve the issue?