Most people combine files from a folder with Power Query all wrong. In this video I show you why it’s wrong and the way you should be doing it.

When Power Query combines files in a folder it automatically creates a bunch of queries for you. There are two queries that are important, the sample file query and the final query.

Most people use the wrong query to make their transformations and wonder why they’re struggling.

Check out the video to see examples of when and why you should use the sample file query vs the final query.

📑FILE DOWNLAD & STEP BY STEP written instructions here: https://www.myonlinetraininghub.com/p...

🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 CONNECT with me on LinkedIn:   / myndatreacy  

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...



⏲ TIMESTAMPS
0:00 How to Combine Multiple Excel Files From a Folder
0:20 The Data & Where to Save it
1:08 Getting the Data From a Folder
3:01 The Important Queries
3:57 When to use the Sample Query
7:36 The Important Stuff
7:53 Loading the Data
8:51 Getting New Data