Power Query refresh sequence

[donkeyshrek]

Hi, wondering how PQ decides which Queries should refresh first, when doing a Refresh All. Is it in parallel? Meaning speed is the determining factor or does PQ actually look into the Query Dependancy tree to check which queries need to be refreshed first for the others to take the more updated data?

If Query B depends on Query A to finish its refresh, will PQ wait for Query A to finish? or just take the outdated data from Query A if Query B finishes its refresh first?

[Anonymous]

In a refresh all, Power Query actually looks at the dependency tree and evaluates everything necessary to calculate the output of all of the queries. If something doesn't need to be evaluated, it doesn't get evaluated.

Whwn refreshing a single query, any anything in the lineage that needs to be evaluated gets evaluated.

--Nate