So what i do is i click Server, publish workbook.
Is that the same thing as publishing the data; while you publishing the workbook?.
Publishing the workbook means you publish the query information only to server.
That means the connection itself is still kept as original excel file with multiple file under some folder with live connection.
That's not good situation.
What should be done is publish "Extracted data" to server.
This allows Tableau server to generate TDE file from original location (periodically based on schedule set)
Then, workbook will be connected to TDE file which is located in server.
Then performance becomes excellent.
Not exact, but some illustrations here
I get point that performance would get better.
But i dun get the point that the datasource isnt published to server while i click publish workbook.
As i saw this on server side:
In the dashboard, i saw data sources tab which containing several data sources. I thought i am uploading the data to server as well?