Using stored procedures and temp tables

tableaucommunity@tableau.com — Thu, 15 Jun 2017 23:08:01 GMT

Hi there

I am fairly new to Tableau and just upgraded to v8.1, with the hope of being able to take advantage using stored procedures as a data source. I am using MSSQL 2008 R2 (64-bit) and have a bunch of stored procedures that I use for authoring reports in Reporting Services. After a few hours of trying to open various SP's as data sources, it seems that Tableau doesn't like that I reference #tmp tables in my sql. I've tested this by creating two simple stored procedures that uses the same data sources, with one using #tmp tables and the other does not. The one that didn't use #tmp tables connected while the other generated a "the stored procedure does not return a result set".

My question -- Is this a known issue? I've had trouble finding any info on this in the forums or knowledge base. If this is a limitation, does anyone have any workarounds? -- or do I need to create extracts instead?

Thanks in advance.

Rich

Content in Tableau Community Forums

Using stored procedures and temp tables