I'm trying to publish the workbook through the api version 3.1. But I get some exception in the log: PublishingConnectionCheckException: Datasource connection check failed.
We use the remote sql server and there are some stored procedures in workbook.I caught some SQL statements using the sql profiler.When executeing SET FMTONLY ON select Exec usp_xxxx SET FMTONLY OFF, db will throw some error:Invalid object name '#temptable'. I think it's not succeed to publish workbook because of these errors.
Any help to solve this error would be much appreciated.