Uploaded April 2024 | Updated November 2026, 2 hours ago
Power Query is great for automation, until it doesn't work because someone (I am not naming them) goes ahead and renames a file or the folder!
Then you witness the slow collapse of your automation domino empire.
In this video, let me share with you a simple and elegant fix to the problem.
Using parameters!
Learn how to automate tasks effectively with Power Query using dynamic folder paths.
β± video topics:
=============
0:00 - Power Query Automation Error (file renamed β )
0:13 - Creating file name & folder path parameters
2:07 - Loading the data and parameterizing the path
3:46 - Fixing the firewall warning error
4:32 - Close and Load customization to get just data (not parameters)
5:11 - Testing with new data
6:03 - What if you want to combine all the data instead?
π combine datasets with Power Query
================================
Combine all files in a folder - youtu.be/SGzegma9bdY
Combine all sheets in a workbook - youtu.be/k_ugshJ4wIw
Combine data from all PDFs - youtu.be/5I0pnj_-LLA
Combine data when heads don't match - youtu.be/ECtJQDc8uF8
Power Query Tips & Tricks Playlist - youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
~
Power Query Crash Course π
=========================
π₯ Get it here before the price goes up to $99 - chandoo.org/wp/power-query-power-course
#excel #automation
Power Query is great for automation, until it doesn't work because someone (I am not naming them) goes ahead and renames a file or the folder!
Then you witness the slow collapse of your automation domino empire.
In this video, let me share with you a simple and elegant fix to the problem.
Using parameters!
Learn how to automate tasks effectively with Power Query using dynamic folder paths.
β± video topics:
=============
0:00 - Power Query Automation Error (file renamed β )
0:13 - Creating file name & folder path parameters
2:07 - Loading the data and parameterizing the path
3:46 - Fixing the firewall warning error
4:32 - Close and Load customization to get just data (not parameters)
5:11 - Testing with new data
6:03 - What if you want to combine all the data instead?
π combine datasets with Power Query
================================
Combine all files in a folder - youtu.be/SGzegma9bdY
Combine all sheets in a workbook - youtu.be/k_ugshJ4wIw
Combine data from all PDFs - youtu.be/5I0pnj_-LLA
Combine data when heads don't match - youtu.be/ECtJQDc8uF8
Power Query Tips & Tricks Playlist - youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
~
Power Query Crash Course π
=========================
π₯ Get it here before the price goes up to $99 - chandoo.org/wp/power-query-power-course
#excel #automation










