Last Modified Date: 13 Jun 2019
- Tableau Desktop 10.3 - 10.5
- Microsoft SQL Server
ResolutionUse one of the following workarounds:
Upgrade to Tableau Desktop 2018.1.1, 10.5.4, 10.4.7, 10.3.11 or a later version. For more information, see Upgrading Tableau Desktop in Tableau Help.
Option 2As appropriate, write the stored procedure to not use EXEC INSERT or reference other stored procedures, and/or change the metadata from VARCHAR(MAX) to something like VARCHAR(255).
Option 3Download the attached "disable exec insert.tdc" and save the file in the My Tableau Repository > Datasources folder.
It may be necessary to update "10.5" in the above file to the version of Tableau Desktop being used
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.
The Microsoft OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statement.
SELECT * FROM