KNOWLEDGE BASE

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


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

Issue

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

Environment

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

Resolution

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' />
    <customizations>
        <customization name='CAP_ODBC_BIND_FORCE_MAX_STRING_BUFFERS' value='yes' />
    </customizations>
</connection-customization>
----------------------------------------------

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.

Cause

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