Two automations to share Power Query results without allowing to refresh the query – T0022
4.9 هزار بار بازدید -
3 سال پیش
-
Power Query is all about
Power Query is all about creating a refreshable connection to a data source and making it easy for us to update the query results. However, sometimes we want to preserve those results without being replaced by future changes in the data source. We invite you to watch this video and learn how to break the link to source data in Power Query.
Find more information about the Enable Background Refresh Property:
Understand the Enable Background Refr...
https://solveandexcel.ca/2020/09/11/e...
________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________
Chapters:
0:08 – Introducing topic and explaining need of disconnecting Power Query table from data source
4:28 – How to disconnect a Power Query Table from the data source
5:30 – Unlink Table from Data Source vs Load as Connection Only
6:59 – VBA to Refresh Power Query Table + Unlink Table from Data Source on a copy of the original file
24:11 - VBA to Refresh Power Query Table + Copy Table data to a new file without including the query
30:55 – Conclusion
…
Join my Telegram Group at https://t.me/celiaalvessolveexcel to access exercise files and other content.
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn: LinkedIn: celiajordaoalves
Facebook: Facebook: solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel
#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA
Find more information about the Enable Background Refresh Property:
Understand the Enable Background Refr...
https://solveandexcel.ca/2020/09/11/e...
________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________
Chapters:
0:08 – Introducing topic and explaining need of disconnecting Power Query table from data source
4:28 – How to disconnect a Power Query Table from the data source
5:30 – Unlink Table from Data Source vs Load as Connection Only
6:59 – VBA to Refresh Power Query Table + Unlink Table from Data Source on a copy of the original file
24:11 - VBA to Refresh Power Query Table + Copy Table data to a new file without including the query
30:55 – Conclusion
…
Join my Telegram Group at https://t.me/celiaalvessolveexcel to access exercise files and other content.
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn: LinkedIn: celiajordaoalves
Facebook: Facebook: solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel
#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA
3 سال پیش
در تاریخ 1400/06/01 منتشر شده
است.
4,921
بـار بازدید شده