221 votesunder review · 11 comments · Power BI Ideas » Data Preparation · Flag idea as inappropriate… · Admin →
49 votesJosh commented
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.