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

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.