1) Create a Extract - Stores the data in local Memory
2) Publish the data source to Tableau Server
3) Open the workbooks which are retrieving 30 M Record every time and Point the workbooks to published data source.
4) Now all will pull the same data source from local memory
Check this link:
hope this helps, Plz mark this answer as correct or helpful to close the thread
Thanks for the answer. I forgot to add that we call the data source from different tableau sites. Is there a way to have reports in different sites share a data source that lives in the tableau server?