Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to Solution.
1. potentially
2. no
3. "refresh all" means "get all rows for the current query", not "refresh all queries".
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.