Folder option not available when selecting data source (Mac)

[statesaver]

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

[Anonymous]

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

[Omid_Motamedise · Accepted solution]

This link can help you by providing a more detailed explanation and providing another strategy.

https://macexcel.com/examples/filesandfolders/filelist/

[Omid_Motamedise]

Unfortunately, this feature is not available on the Mac, you might use Excel 365 for such scenario

[PwerQueryKees]

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