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. Jim G 134K Reputation points MVP
    2022-07-18T14:13:29+00:00

    Hi

    You posted to the Office Insider forum, which is for Beta Channel users. The version you have is not the current Beta Channel build.

    To get the Beta Channel Build use the Help menu in Excel. Choose Check for Updates, which launches AutoUpdate app.

    In AutoUpdate, click the Advanced button, then switch Update Channel to Beta Channel. Once you have installed the Beta Channel update, you should find PowerQuery on the Data tab of the Ribbon.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-07-19T21:37:57+00:00

    Hello,

    I was having the same issue, select the beta channel and download/install process. You then need to restart your Mac for the power query editor button to pop up.

    Best,

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-08-08T09:01:14+00:00

    Hi Jim,

    I am having the same issue as Nathalie Doms1 did.

    • I have a Office365 Subscription
    • I have completed all updates
    • I have BETA Channel selected
    • I have restarted my MAC

    and still no Launch Editor available.

    Can you assist please.

    Nathalie Doms1 did you get this to work?

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  4. 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
  5. 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