Benjamin Bisch on 07 Sep 2016 14:11:51
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
Then 2
Then 3
etc...
This would allow us to control how our workbook will refresh with the loading of data sources.
- Comments (5)
RE: Refresh priorities
What Brian said, over three years later. Three years.
RE: Refresh priorities
This would be even better if users were allowed to schedule refresh intervals at the individual table level. Some tables need refreshed daily, while others may need weekly or monthly updates.
RE: Refresh priorities
This work in PowerBI desktop, but how to set up this in PowerBI service (cloud version)?
RE: Refresh priorities
Still a problem.
RE: Refresh priorities
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.