I am connecting to a MS SQL DB on a private network. The client requires the datasource connection to be live as they want the reports to update in real time. The SQL Db performance is pretty fast, as the tables in SQL get updated in a matter of seconds however when I use Tableau Desktop to build and publish my reports, it takes forever to load the dashboard on Tableau Desktop. When I publish the datasource itself, it is fine however whenever I try to publish the workbook, it takes forever(couple of hours). I am struggling to troubleshoot whether the issue is in SQL or on Tableau Desktop. My internet speed is pretty fast and when I use extracts it works like a charm however I cannot use extracts for this project so I am desperately trying to find a way to fix as this is extremely critical that the connection is live.
Any assistance would be greatly appreciated.
If the queries are taking hours to run, then the problem is your database and your dashboard. Basically your dashboard generates a query which takes too long for your database to run. Our whitepaper https://www.tableau.com/learn/whitepapers/designing-efficient-workbooks might help you. You can click on the performance recording and see the slow query. If you can share that query with us, we might be able to suggest specific changes.
Dan
