KNOWLEDGE BASE

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


Published: 02 Jan 2018
Last Modified Date: 15 Feb 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.2 and 10.5.0
  • Windows
  • MS SQL Server

Resolution

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 Issue ID 729054, which is currently being investigated by our development team.

Additional Information



 
Did this article resolve the issue?