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.