Hi @chris786,
Think there are a couple of things you could consider/examine:
- Are there options to optimize the queries themselves? Look into Query Diagnostics.
- Consider saving your historic data (before 2021) in CSV instead of XLSX
- Can you off load some of the work to Dataflows?
- Consider Incremental refresh, see article in post below if you are using Pro
I hope this is helpful