Forum Discussion
Folder option not available when selecting data source (Mac)
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:
- Excel workbook
- Text/CSV
- XML
- JSON
- Sharepoint
- OData
- Blank table
- Blank query
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
This link can help you by providing a more detailed explanation and providing another strategy.
https://macexcel.com/examples/filesandfolders/filelist/
4 Replies
Unfortunately, this feature is not available on the Mac, you might use Excel 365 for such scenario
This link can help you by providing a more detailed explanation and providing another strategy.
https://macexcel.com/examples/filesandfolders/filelist/
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
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
