Is there any method in Tableau, any settings or configuration adjustments, to speed up the first load of dashboards on Tableau Server? When someone accesses one of my high-performance dashboards on Server for the first time, it can take several minutes to load. This is excruciating.
Tableau Desktop 9.3 is what we're utilising. Both "Tableau Desktop" and "Tableau Server" are experiencing performance issues. The following is an observation: SQL Server as a source 2 SQL views in the dataset (extracted) 6 million records
Just a little background on how we came up with this dashboard. Pricing data is in one dataset, and billing data is in another. We made a heat map and two bubble charts to illustrate billing by client and two subcategories (All using Billing data) With consumers, we've established a cross tab to show part prices by "Region" (All using Pricing data) We've made a scatter plot to show how Price and Bill interact (Data blending) We created approximately 10 parameters for Filters because we have two separate datasets.
After putting all of these sheets and parameter controls in one dashboard, we saw that it takes between 60-90 seconds to open the initial view, whether on the server or on the desktop; after that, it's relatively speedy even if I use numerous filters. However, when I reset all of the filters, it takes around 60-90 seconds to return to the Original View. We only have 6 million records in total when merging both datasets, so we're stumped as to why things are taking so long. We'd appreciate your help figuring out where we're going wrong.