Hello Keith R,
I am moving this to Server Admin section of the forums where someone is more likely to assist.
I'm also curious if this issue occurs for all views using this data source? For all views regardless of data source? and any other information to help narrow down the source of the lag. Oh and what version of Tableau Desktop and Server are in use?
Desktop and server are v8.2.
When clicking on the workbook (on the server), I can choose from three sheets, all of which experience the lag (whichever one is loaded first). For example, if I load sheet1 first, it takes 20+ seconds but then switching to the other sheets is at most a few seconds. If I close it out and start from scratch with sheet2, it takes 20+ seconds to load, but then Sheet1 only takes a few seconds at most to load.
views from other data sources (like SQL server) do not experience the same lag. The source data is being extracted from an Excel 2010 (x32) workbook.
Thanks for any advice!
keith, Where is the excel source located? Are you using an extract of the excel?
Is this what you're doing?
-Connecting to an excel source
-Creating an extract
-Creating your workbook
-Publish to the server
Here is the reason why the load time more,
When you open a workbook which is published on the server, the server is trying to open the workbook from the extract which is located on your desktop. The server keeps trying to locate your extract and certain points gives up and loads what's in the memory. This is where the lag appears.
The best way to work with excel as source is to make sure you give the UNC path when you publish the workbook. Make sure the UNC path is where you tableau server can ping and reach quickly.
If you can't place the excel in a shared location, you can do the following,
1) Open the workbook which is connected to the excel
2) Create an extract, generally created in you local machine.
3) Now you have connect to the extract
4) Replace the datasource to use the extract
5) publish the workbook and use the option use external files option
you're dashboard should load very quickly.
PS: once the extract is created, you can publish the extract to the server and connect the workbook to the extract. This should also increase the load time.