I have a Tableau dashboard having excel as data source and I have used extract instead of live connection.
While publishing, I have set data source properties to "Embedded in workbook" .
When I run extract manually on Tableau server, it fails with a message that file could not be found and check for permissions.
I have stored excel on Tableau server and I have the access to view and modify this file on Tableau server.
If I publish data source separately instead of embedding in workbook then I could successfully run extract on Tableau server.
Could you please let me know if "embedded in workbook" option works for excel if we want to refresh extract on Tableau server.
Please review this document: Updating Underlying Data in a Tableau Server Workbook That Uses a Live Connection to Excel | Tableau Software
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...