I'm assuming by "tab" you mean a new dashboard or sheet, not just a sheet that exists in your dashboard? Are you publishing with "Show Sheets as Tabs" selected? If so, I would recommend benchmarking this against a workbook without tabs being published and see if this improves your load times.
Hey Ben...thanks for the reply.
Yes, each dashboard sheet is being published as a tab. I'll get with the dashboard owner to test out (may take a bit due to other items.)
However, are you thinking that if this works Tableau was considering all the tabs active? Thus trying to query every one of the connections at once regardless of what dashboard sheet we were on when published.
If that is the thinking, it kind of goes against what I know about how a live connection impacts a dashboard. Correct me if I'm wrong but a live connection impact should only be felt when that particular view is accessed. A dashboard sheet/tab being surfaced when the workbook is published should not constitute as being accessed. Rather, I would assume 'active' isn't until that sheet/tab is selected which then sends the query to the data source.
Or is that all just crazy thinking?
It's possible I am mistaken, but as I understand it, publishing sheets as tabs does not affect performance EXCEPT for the initial load of a view. I believe at this point we do something behind the scenes to open up a connection or load metadata. Subsequent clicks/filtering shouldn't be affected, as Tableau does nothing with the tabs after the first load.
If the datasource is the same, there should be no performance hit. However, what you are describing sounds like 2 distinct connections, which may be the issue. I would suggest trying this without tabs to validate my suspicions.