When using the refresh function with Power Query, the system will automatically run the queries according to their dependency in the right order.
However, it prove the task difficult when using Query Folding for example, and I have to manually refresh each Query that I folded first, before refreshing the main process chain.
Would it be possible to set up a refresh priority in Power Query between queries?
When Excel hit the "Refresh All" =>
Do all queries (and dependencies) with priority 1
This would allow us to control how our workbook will refresh with the loading of data sources.
Still a problem.
This is a serious hidden issue, and should be tackled before any UI/visualization upgrades. Not only is the data refresh order opaque to the user, but it's not consistent. Sometimes the refresh executes with missing rows of data. When it does, it doesn't even throw an error message. This is all due to Power Query having no native way to designate query priority.
I have had to use VBA and multiple refreshes to work around this issue, which contributes to a lack of trust for the software. If you search for the issue, you'll notice there are a lot of different problems people are having that can ultimately be traced back to this issue.