Forum Discussion
Solved
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: E...
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