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: Most helpful
Most helpful Newest Oldest
  1. 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
  2. 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
  3. Anonymous
    2022-08-10T11:47:57+00:00

    Hi,

    There is no check for updates option in the Help menu. Is there an alternative way?

    Looking for your reply.

    Cheers,

    ![](https://learn-attachment.microsoft.com/api/attachments/72591bed-9626-48e2-96b2-4dc47265a4f9?platform=QnA

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Jim G 134K Reputation points MVP
    2022-08-09T14:22:49+00:00

    Hi

    If your subscription is managed or is of a type that allows feature updates only once or twice a year, you may have to wait to have access to the feature.

    When any new feature is rolled out in the beta channel, one group of testers gets the new feature and another does not and acts as a control. This allows Microsoft to compare behavior of Excel with and without the new feature in case there's crashes, compatibility problems, etc.

    Having all the necessary background does not guarantee you will be in the group that gets a particular new feature. If you do get a new feature, it could be active one week and not active the next when you install the weekly update. Getting a particular new feature to test in the beta channel is not a sure thing.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more