How can we improve Power BI?

Refresh priorities

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.

44 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Benjamin Bisch shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Josh commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.