Issue
After a Microsoft update, Tableau connections to stored procedures on Azure SQL Data Warehouse fail.
The following error can be found in tabprotosrv.txt : Invalid object name '#Tableau_X_Y_sp_temp'. SQLSTATE_DDL_BASE_TABLE_NOT_FOUND
Last Modified Date: 16 Sep 2020
Environment
- Tableau Desktop
- Microsoft Azure SQL Data Warehouse (Azure Synapse Analytics)
- Stored procedures
Resolution
- Upgrade to Tableau Desktop 2020.2.5.
- Use a .tdc file like the attached to apply the Microsoft recommended customization:
UseFMTONLY=Yes
Cause
This behavior is related to a Microsoft known issue. For more information, see Retrieving ParameterMetaData via useFmtOnly at Microsoft.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials