Excel Power Query - How to speed up

[Number1One]

Any tips to speed up a slow Excel power query is appreciated.
Main tip i would love to have is how to refresh just 1 end table without having all the data reloaded from all the sources etc

 

[GraH]

If your finale Query needs the others, there is no way to only refresh the last one, as PQ traces dependencies.
A way to speed up is to buffer some tables if you do some merges. But in the end it does depend on the global definition of all your queries in play.

Recently I followed an alternative approach where I have my data staging queries in different workbooks and my finale queries in again dedicated workbooks that can re-use any of the results of my staging queries.

That way the refresh of my result queries is way faster.

 

[Number1One]

Appreciate it, have trialed with Buffer Tables and seems to make a difference until I brought sharepoint into it then it took ages. May have a try at separate workbooks and see if that helps thanks

 

[Matt Allington]

SharePoint will always be slow - it’s a dog (SharePoint, that is). Can you sync the SharePoint files to your pc and sync from your pc instead?

 

[GraH]

I wonder why that is. It seems to take forever before the connection to the file is made. Maybe it needs to scan through all the file versions? I read somewhere that the API is not ideal, but I'm no techie.
The sync tip is something to consider.