Forum Discussion
Wanting to pull data from multiple csv files using 'get data'
PQ on the Mac still has quite some shortfalls comparing to it's big brother on the PC. The missing Files from Folder connector is one of them. But, the attached link takes you to MrExcel.com (Bill Jelen's web site) where it is explained how some of the 'gaps' in PQ on the Mac can be filled.
https://www.mrexcel.com/excel-tips/power-query-debuts-for-excel-for-mac-but-with-significant-gaps/
If you prefer not to click on a link, go to his web site and search for "power query mac". The first hit will be the article in the link.
The "from Folder" option can be 'enabled' by entering a short code/command in the "Immediate Window" of the Visual Basic Editor. Now you can use the Folder.Files function in PQ for the Mac. Tested it myself and it works as shown and explained in the video.
Thank you Riny. This is what I've been using. Do you know if there's a limit to this? As in a limit of how many files or rows I can combine at once?