Do I understand it correct that your published data source is an extract?
Yeah, it is an extract.
You are probably retreiving so much data that it takes about an hour.
Have you tried filtering it for like the last 2 years?
Another option is to create multiple smaller data sources that are more relevant for the reports that are using them.
Not 1 big data source.
If I understood correctly, the workbook that uses published data source simply has a connection that points to the extract that is stored on the server.
Because of this, we thought we could minimise the time refreshing the same extract multiple times by having a published data source.
Therefore, it's a bit counter-intuitive for us that the refreshing the extract takes 30 minutes, but simply loading the results on Tableau server takes 60 minutes
Does this mean in this case, I would rather have extracts embedded in the workbook, refresh the same extract multiple times, rather than published to the server?
On the other hand, I do agree with smaller data sources and limiting the history as a good practice approach. However, our client insists on having a very low level of detail as well as full history.