KNOWLEDGE BASE

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


Published: 02 Jan 2018
Last Modified Date: 27 Mar 2018

Issue

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.
OR
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]String or binary data would be truncated.

Environment

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

Resolution

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).

Cause

This behavior is related to a known issue with ID 729054, which has been corrected in more recent versions.

Additional Information



 
Did this article resolve the issue?