Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Txtcher
Helper II
Helper II

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.  Below is an image of the queries I built whose sources are Salesforce objects.  I created 2 folders, one for Staging which contain the original source queries and all the transformations executed on the data.  The Reference folder was created to hold references to each of the queries in the Staging folder.  The Other Queries folder contains 2 merge queries.  The first query named Apps_AppEntities is a merge between Application and Application Entity.  The final query, Accounts_Apps_AppEntities, is a merge between Apps_AppEntities and Accounts which produces the final table.

My questions are:

1.  Does setting up reference queries speed up performance when using them in a merge?

2. Do queries refresh in the order in which they are listed, from top to bottom?

3.  When I click Refresh All (each query's properties are set to refresh with Refresh All), the Queries & Connections pane only indicates the last query is refreshing.  How do I know all the preceding queries are also refreshing?

Txtcher_0-1715979028223.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1. potentially

2. no

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

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

1. potentially

2. no

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

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?  

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors