Loading

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

Publiseringsdato: Feb 19, 2026
Beskrivelse
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

Cause

By design, memory limit has been reached.
Løsning
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.
Knowledge-artikkelnummer

001474815

 
Laster
Salesforce Help | Article