Launch power query editor on Mac

Anonymous
2022-07-18T09:11:21+00:00

Good day

I am trying to get access to Power Query Editor on Mac. I have done the latest Excel beta and current channel (preview) updates as required and currently have Excel version 16.64 installed, but still don't have a Power Query Editor option. According to Office Insider this feature is available to Beta Channel users running Version 16.61 or later.

Attached is a screenshot of what I should be seeing according to Office insider when I select get data in the data tab, and a screenshot of what I'm actually seeing.

ImageImage

I do have a Microsoft 365 subscription, I have the bèta channel but still not able to see the launch power query editor button.

Microsoft 365 Insider | Excel | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

17 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2022-09-23T00:48:32+00:00

    welp this is lame

    I had access the editor for a day, and did some significant work with it.

    now I don't see it anymore, and the Check of Updates option is gone.

    I guess all that work went to waste then... pretty crazy to be honest..

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Jim G 134K Reputation points MVP
    2022-09-25T16:20:01+00:00

    Hi giantqtips

    Download a copy of the current version of AutoUpdate from this link, install and then run AutoUpdate to bring your installation to current update level, then restart your Mac. If the updater does not open automatically after download, double-click the downloaded .pkg file. Click this link to download the updater. The update is free.

    https://go.microsoft.com/fwlink/p/?linkid=830196

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-10-05T10:00:57+00:00

    It appears your install of Office is managed and that the IT department does not allow you to join the beta channel.

    Hi Jim, how do I grant that access to the user? because I can't find the menu to give that access.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Jim G 134K Reputation points MVP
    2022-10-05T16:49:55+00:00

    I don't administer licenses. This organization might help you:

    Our Mission — MacAdmins.org

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-10-18T09:29:56+00:00

    Hello giantqtips, I had the exactly same issues.

    I downloaded first the excel from the office 365 from my university site and launch query doesn't wanted to launch even when I had the beta channel. I uninstalled it and download the excel from the AppStore. Boom I restarted the Mac and the power query had been shown to me but only for one day as the next day I did not find it anymore.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments