Switching to the extracts seems to be the right call here but I believe it will have to be done from within Tableau Desktop: I.e.
-In TD, create extract
-Make new connection to published data source
-Replace original extract with publish extract
Let me know if i've missed something. Thanks for posting!
1) Connected to excel, created an extract(saved it locally) and published the extract. I don't get an option for 'Including external files'. This option seems to appear only when using live connection. I'm on 8.2.2
2) Publishing this to the server and replacing the workbook to use this extract still is trying to reference the extract file that was generated on local machine(created in step1) increasing the render time.
I have the same problem.
I'm working with extract from CSV-files locally on my computer, and publishing workbooks on the server. Now I have many workbooks on the server, but I have to update each of them individually and upload the all the data each time. I can upload the csv extract as a data source on the server, but I can't switch the connection in the workbooks to the new data source (csv extract on the server).
How do I connect the workbooks on the server to one extract?
Would be so much easier if I could just upload an updated csv extract to the datasource on the server.