KNOWLEDGE BASE

Stored Procedure returns no results when connecting to Microsoft Azure SQL Data Warehouse


Published: 10 Aug 2018
Last Modified Date: 10 Aug 2018

Issue

When connecting to a stored procedure in Azure SQL Data Warehouse, Tableau Desktop 2018.1 returns no values.

Additionally, you may notice that the logs might containt the following error:

"[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Parse error at line: 1, column: 32: Incorrect syntax near 'EXEC'." 

Environment

  • Tableau Desktop 10.4.2 and later
  • Microsoft Azure SQL Data Warehouse

Resolution

Option 1

Upgrade to Tableau Desktop 2018.1.4 or later. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2 (Workaround)

If you are unable to upgrade, the issue can be worked around using a TDC file to disable the INSERT ... EXEC syntax as detailed in the Tableau Knowledge Base article below: No Data Returned Connecting to Stored Procedures Containing VARCHAR(MAX) or EXEC INSERT
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.
  • Please note that this workaround might have an impact on performance. 

Cause

This behavior is related to a known issue (ID: 782421) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?