Hi Gasper. Awesome tutorial! Really appreciate the detailed explanation which is so helpful when learning new techniques. Also appreciate you providing the sample data to follow along. Thanks for sharing :)) Thumbs up!!
Why do you have to get the file content with a function with 2 parameters, when you can use Excel.Workbook([Content]): exceloffthegrid.com/power-query-import-all-files-in-a-folder/
I totally get what you are saying, and if all the content of the files is nothing but Sheets than what you are saying would definitely work. The problem is our custom function only works on Sheets, but far more often than not, Workbooks contain named ranges, print areas and tables along with Sheets. And that extra step is to make sure, we are feeding our function with Sheets only. Hope it makes more sense now.
Another great explanation! I have done file from folder so many times but did not realize that I could and should control so much. I never filtered for ~ before - great tip! Plan for possible variations in files - and ensure you only get the data once, but you get all of it. Thanks!
Thank you very much for this tutorial. I am very new to Power Query and trying to consolidate daily timesheets from multiple files. I watch many UA-cam tutorial videos but nothing works until I found yours. it works like a charm :)
Hi Gasper. Awesome tutorial! Really appreciate the detailed explanation which is so helpful when learning new techniques. Also appreciate you providing the sample data to follow along. Thanks for sharing :)) Thumbs up!!
Always a pleasure Wayne!
Hi Gasper, @ 4:22 you used a cool cursor trick! Can you tell us what app you use for that annotation?
Thanks!
Hi Geert. So this is Zoom It. It's part of Sysinternals by Microsoft. It is free and requires no Installations.
Thanks a lot for this great video and explanation. I am a newbie in pq functions and parameter....but this helps me to understand more...
Great to hear that. One step at the time and before you know it you'll be using them everywhere.
Why do you have to get the file content with a function with 2 parameters, when you can use Excel.Workbook([Content]):
exceloffthegrid.com/power-query-import-all-files-in-a-folder/
I totally get what you are saying, and if all the content of the files is nothing but Sheets than what you are saying would definitely work. The problem is our custom function only works on Sheets, but far more often than not, Workbooks contain named ranges, print areas and tables along with Sheets. And that extra step is to make sure, we are feeding our function with Sheets only. Hope it makes more sense now.
Great tutorial! Thank you very much!
Glad you found it helpful, Elena!
Great tutorial! thanks a lolt
Thanks Maan.
wonderfull!!!
Thank you.
Another great explanation! I have done file from folder so many times but did not realize that I could and should control so much. I never filtered for ~ before - great tip! Plan for possible variations in files - and ensure you only get the data once, but you get all of it. Thanks!
You are welcome Grainne. And aint it a great day when we learn something new in Excel.
Wow. That was a great demonstration with lots of cool and interesting tips. Looking forwards to viewing more. Thumbs' up!!
Glad to hear that Roderick.
Great video! Really like how you explain power query
Thanks Alan. Means a lot!
Thank you very much for this tutorial. I am very new to Power Query and trying to consolidate daily timesheets from multiple files. I watch many UA-cam tutorial videos but nothing works until I found yours. it works like a charm :)
Thank you for those kind words Wantana. Glad you got it working and even more glad that Power Query fan club has a new member 😀
wow! incredible!
Thank you for those kind qwords V A. It means a lot.
Amazing trick
Thank you for those kind words Syed.
I have seen different methods of doing this, but by far yours is the best one. Thank you, and keep doing what you do.
Thanks, will do!