No Data Returned Connecting to Stored Procedures Containing VARCHAR(MAX) or EXEC INSERT

Published: 15 Feb 2018
Last Modified Date: 05 Mar 2018


When connecting to stored procedures containing EXEC INSERT or containing or referencing fields set to VARCHAR(MAX), no data is returned.


  • Tableau Desktop 10.3 - 10.5
  • Microsoft SQL Server


Use one of the following workarounds:

Option 1:

As appropriate, write the stored procedure to not use EXEC INSERT or reference other stored procedures, and/or change the metadata from VARCHAR(MAX) to something like VARCHAR(255). 

Option 2:

Download the attached "disable exec insert.tdc" and save the file in the My Tableau Repository > Datasources folder.
It may be necessary to update "10.5" in the above file to the version of Tableau Desktop being used

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 behavior is related to known issues which are currently under investigation.

Additional Information

Additional details about this issue can also be found in the following third party article
Did this article resolve the issue?