Understand the Enable Background Refresh property in Power Query in Excel

Опубликовано: 19 Октябрь 2024
на канале: Celia Alves - Solve & Excel

12,924

145

This video is about the "Enable Background Refresh" property in Power Query in Excel.
I will go through a couple of examples to demonstrate what this property does to query refreshing behaviour and to explain why it is important to pay attention to how we choose to set this property in our Power Query projects.

Links Mentioned:
Uservoice idea - make "Enable Background Refresh" unchecked by default - https://excel.uservoice.com/forums/30...

Date Picker add-in by Sam Rdakovitz - https://samradapps.com/datepicker
Video Tutorial by MrExcel:    • Excel - Free Date Picker Tool - No Of...
(Subscribe to MrExcel Youtube Channel!)

Fake Daya add-in by Sam Rdakovitz - https://samradapps.com/fake-data
Video Tutorial by MrExcel:    • Excel - Creating Fake Data in Excel M...
(Subscribe to MrExcel Youtube Channel!)

0:00 - Introduction
0:38 - What is and where to find "Enable Background Refresh Property"?
4:10 - Power Query Tables and Pivot Tables
10:14 - Power Query Tables and VBA
18:14 - Excel UserVoice idea to vote
18:45 - Excel Date Picker and Excel Fake Data add-ins

----------------------
My Contact information:
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca/
LinkedIn:   / celiajord.  .
Facebook:   / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel

--------------------------
Learn Excel and connect with a community of Excel professionals and enthusiasts:
MS Excel Toronto Meetup Group - https://www.meetup.com/MSExcelToronto/

Learn how to automate your Excel Reports: https://snapreportschamp.com/