Are cross database joins not supported when one of the sources is stored procedure?
I am using Tableau 10. One of my sources is SQL server stored procedure and I wish to join an excel file to it.
However, as soon as I drag the stored procedure as one of my sources, the button to add an additional connection gets disappeared.
I checked all the information provided about cross database joins, however could not see a SQL Server stored procedure in the unsupported sources list.
Can someone throw some light on this?
Unfortunately, logic we use to support stored procedures is not compatible with cross-database joins.
We will indeed remove "Add" button of you are using stored procedure and will gray out list of stored procedures once you add second connection to datasource.