I want to get data from a local Excel file to set up Power Query but I don't get this option on my Mac - see screenshot attached. I'm on Monterey OS and have an up-to-date 365 for Mac subscription. Can anyone explain why Google search results show the option to select Excel and csv files when using Power Query on a Mac but this isn't available on my MacBook? Am I missing something obvious or is this only available for Insider users?
Hi Christine,
This feature is available to Beta Channel users running Version 16.50 (Build 21050400) or later, as mentioned here: https://insider.office.com/en-us/blog/import-data-from-local-files-with-power-query-in-excel-for-mac
Hopefully it will be released soon to all users, seems to be still in Beta since May 2021.
Hi all,
Power Query edit is now available on the MS Office 365 for Mac (Beta Channel) and it's really good. So far, the only top-level omission that I've seen is the ability to lad from a folder, but I think that's coming.
This is a game-changer for Mac users!
By the way, and quoting from another thread, if you have code designed to work on Windows and Mac that includes a folder query, you can test for Operating System, then use a new property to exclude it when running on a Mac:
ActiveWorkbook.Connections("Query - <your query name>").RefreshWithRefreshAll = False
Substitute the name of your query between the angled brackets.
Hope this helps.
