Refreshing twice in Power Query in Excel? Why? Fix it now.

If you need to hit Refresh All twice to get your Power Query queries to fully update, this video shows a possible reason for that to happen and how it can be fixed.
And it is NOT about the Enable Background Refresh property.
The last 10 minutes contain two extra bonus tips to help you refine your tools and make your Excel applications even more robust and efficient.
One thing is to start to use Power Query and automate data importation and transformation with it. Anyone can do it, and if you never tried it, start now!
The next step is to understand what happens behind the scenes when we build multiple queries in one solution and how to ensure that the procedure is the most efficient possible.
Download the exercise files to practice along with the video and make the techniques explained stick for good.
----------------------------------------------------------------------------------------------------------------------

📖 BOOK: “Master your Data with Power Query in Excel and Power BI”
https://www.e-junkie.com/ecom/gb.php?...

👉 Get access to the EXERCISE FILES at https://snapreportschamp.com/exercise...

👉 Learn how to AUTOMATE YOUR EXCEL REPORTS at https://snapreportschamp.com/course

👉 Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

👉 To learn how to solve the issue of having to refresh all twice to get both query tables and pivot tables updated check: https://solveandexcel.ca/2020/09/11/e...


Celia Alves - Microsoft MVP & Certified Trainer and Excel Expert, Solutions Developer

Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn:   / celiajordaoalves  
Facebook:   / solveandexcel  
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www//   / celiaalvessolveexcel  

0:00 - Presenting the case scenario where queries needed to be refreshed twice
1:18 - Explaining the exercise files content
2:46 - demonstrating the issue of having to refresh twice
4:30 - inspecting data sources, query steps and loading destinations
7:07 - Celia introduces herself and her training program - Excel Snap Reports - about automation of Excel Reporting procedures
7:29 - exploring query dependencies
8:35 - discovering columns with Excel formulas in the query tables
12:00 - the solution
12:28 - scenario where refreshing twice is needed
28:08 - the concept of staging tables in Ken Puls and Miguel Escobar's book "Master your Data with Power Query in Excel and Power BI” as a technique to help improve query performance during the development phase

#powerquery #refreshall #excelatomation