Forum Discussion
Solved
Can't find Power Query tool in Excel for Mac?!
Hi there, hope you are well. I've just bought Office for Mac and I'm struggling with finding the Power Query tool in Excel as described here: https://support.microsoft.com/en-gb/office/import...
Riny_van_Eekelen Thanks for connecting me with jskafte!
After discussing this with jskafte, the following steps have solved the issue:
1. Sign out from your Office account (in the Excel for Mac app)
2. Close Excel by right-clicking on the Excel app on the Dock and pressing "Quit"
3. Re-open Excel and Sign in back to your Office account
Thanks
Gal
Excel Team
Update: Microsoft Office 2024 Home & Business". (one time more expensive office product) seems to have support for this on mac.
If you need to open a query go to Data > Get Data (Power query) more options little button > Data Source Settings.