This is due to because your backgrounder default query limit 2 hrs. any workbook extract taking more than that will get failed showing the error time out
check the below link for resolution:
There would be no difference for embed data source and published data source extract times will be same or little bit less.
Hope this helps
plz mark this answer as correct or helpful to close the thread
Thanks for your reply.
For various reasons I will not go into, we are not going to change the 2 hour limit.
My questions was really about the time to run 6 embedded data sources, which run first 1, then 2, then 3, 4, 5, and 6. vs running 6 published data sources.
The differences is that the published data sources all could start at 7:30 am.
Would the second option be better to try to finish within the 2 hour limit?
If I understood correctly.
You have multiple datasources in a workbook. You want to replace them with published datasources on tableau server.
I would right click on datasource and click on "publish to server". you workbook will automatically replace local datasource to published datasource. Then you can schedule refresh seperately.
I didn't get the first time that multiple data sources are there if thats the case yeah you can publish the data source and as well you can schedule the extracts to run parallely if there is no dependency on one other so that they will get completed under 2 hrs.