Order in which queries will run / refresh?

[tmacg7]

I thought I read something somewhere (Data Monkey book?) that Power Queries will run / refresh in alphabetical order based on their names. Is that true? So if you want to force the order of the query refreshes (i.e., you need one query to run and finish before another that is dependent on the first), you should probably just name them things like "0001_ExampleQuery" and "0002_ExampleQuery", etc.? Is that the best way to do this? I keep naming my queries things like "Q_010_..." and Q_020..." and I try to go in steps of 10 or so, so that I can insert more queries between them later if I forgot something - like I could add a "Q_011..." in between those prior two. But sometimes I mess this up and then have to rename a query to fix the order, and then that causes issues where it has to get deleted from the data model (and relationships deleted).

Am I making it more complicated than it needs to be? How come I don't seem to come across other people naming queries this way? But then when I search for how to refresh queries in a particular order, what I usually find is a bunch of complicated looking VBA to do it (complicated to me because I don't know VBA). Am I missing something? Or shouldn't there just be a setting on each query where you can assign a number for it to base the query refresh order on? And that way you could get rid of the query prefixes and also not have to rename queries and break things when you need to change the order?

Thanks to anyone who can help me understand this better!

 

[Ken Puls]

The alpha order applies to individual queries. If the query has children that feed it, then those will be refreshed when a parent query is refreshed.

The only time this really matters is when you need to refresh and complete a load to table in order to feed another query. (Which usually requires VBA.)

Outside those edge cases, refresh order generally takes care of itself.


Sent from my iPhone using Tapatalk

 

[tmacg7]

OK, excellent to hear. I figured I must have been making it too complicated. Thank you!