Powerful trick to get data from any folder in Excel (works even after renaming!) @chandoo_
Powerful trick to get data from any folder in Excel (works even after renaming!)  @chandoo_
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
Powerful trick to get data from any folder in Excel (works even after renaming!)Excel formula to get CLOSEST Matching ValueIntroducing Free Data Analyst Course - SQL / Excel / Power BI / Python3 Things I do in my new Job to Succeed as a Data Analyst3 Powerful Data Slides for your NEXT Presentation (Free PPT File)Excel PROs use these hidden features to work faster πŸš€Test Your SQL Skills With These Real Interview Questions!FILTER Function Hacks That Save Hours of WorkPower Query - Beginner to PRO Masterclass in 30 minutesThe little known BYROW function changes how you write formulas in Excel 🀫Mind-blowing Excel Trick - MODE for TEXT VALUES!How to make payroll & pay slip calculator in Excel (with sample file πŸ“„)
Chandoo |

Powerful trick to get data from any folder in Excel (works even after renaming!)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER