Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I am attempting to connect a folder when using Power Query to search across multiple files on my Macbook Pro. I go to Data > Get Data, which then opens a window with the following options:
I tried Excel workbook and Text/CSV, but both options prompt me to select a single file. I cannot use shift+click to select multiple. Has anyone experienced this on the Mac and how do you enable folder selection?
Thanks
Solved! Go to Solution.
This link can help you by providing a more detailed explanation and providing another strategy.
https://macexcel.com/examples/filesandfolders/filelist/
Hi @statesaver ,
Did you find a solution? Did the answers help? If so, mark the reply as a solution, which will help the next user with a similar problem, thank you~!
Best Regards,
Gao
Community Support Team
This link can help you by providing a more detailed explanation and providing another strategy.
https://macexcel.com/examples/filesandfolders/filelist/
Unfortunately, this feature is not available on the Mac, you might use Excel 365 for such scenario
It may not be availble in the menu's, but it may be available in the M language using https://learn.microsoft.com/en-us/powerquery-m/folder-files...
Select Blank Query, then paste this in the formula bar:
= Folder.Files("the path to your folder here")
If this works, you could consider
Check out the July 2025 Power BI update to learn about new features.