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/
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