What are you connecting to?
Without examples of the queries it's quite difficult to suggest something but changing/tweaking sheets/dashboard will affect queries Tableau generates.
Where is slowdown coming from? Heavy filters (introduced by filters and quickfilter controls)? Subqueries (introduced by LOD calculations, TOP N filters)?
As for timeout - you can't set them on Tableau Desktop but there's configuration for that on Tableau Server which will work for both published dashboards and published datasources. I'd look here for that..
In this case, it's an end user who's setting up data connections that are crashing the DB. I took a look at the query and noticed a few things that I'd like to optimize.
The user does a whole lot of joins, and at the very end of the joins filters the results on if they have an active order. Were I to do this query in the DB, I'd have pulled a list of the active users and filtered the joins on that data using a with statement in order to pull a lot less data.
At first glance, that's the first thing that I think really needs to be optimized. I suspect that the only way of doing this is through data blending but wanted to check.
Not sure if this is still useful for you but there it is:
It is possible to edit the query.
- Select Data> Convert to Custom SQL
- A window will open and there you can enter the code for your custom SQL.
Hope it helps!