Forum Discussion

Txtcher's avatar
Txtcher
Helper V
2 years ago
Solved

Understanding The Order In Which Queries are Refreshed

I am using the Power Query Editor in Excel because all I need to produce is a final table.  As I am relatively new, I would like to ensure I am using best practices when setting up the queries.  Belo...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    1. potentially

    2. no

    3. "refresh all"  means "get all rows for the current query", not "refresh all queries".  

Txtcher's avatar
Txtcher
Helper V
2 years ago

I definitely do not understand how "Refresh All" only refreshes the current query.  WTH is the point of putting "All" in that menu item?  For that matter, why have "Refresh" and "Refresh All" if they do the same thing?  

lbendlin's avatar
lbendlin
Super User
2 years ago

I agree that the wording could be better.  Keep in mind that Power Query Editor is not where refreshes actually happen. Those take place in Power BI (where "Refresh"  really means "Refresh all partitions" - unless you specifically select individual tables and only refresh those.