Tableau Desktop Returns 0 Rows of Data from Stored Procedure on SQL Server

Published: 02 Jan 2018
Last Modified Date: 04 Jan 2019


When Tableau Desktop is connected to a stored procedure on SQL Server, there may be no rows of data returned. 

The following errors may be seen in the Desktop logs:
[Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]String or binary data would be truncated.


  • Tableau Desktop 10.3.6 - 10.3.7, 10.4.2 - 10.4.3 and 10.5.0 - 10.5.1
  • Windows
  • MS SQL Server


Option 1:

Upgrade to Tableau Desktop 10.3.8, 10.4.5 or 10.5.2. For more information, see Upgrade Tableau Desktop

Option 2:

A possible workaround is to use varchar(n) in place of varchar(max), where n is an appropriate number for your data (from 1 through 8000), e.g. varchar(30).


This behavior is related to a known issue with ID 729054, which has been corrected in more recent versions.
Did this article resolve the issue?