I'm having issues with Power Query Editor. I've followed all the steps to install this function into my Excel (Mac user) but I still don't have it. I even went for the Beta Option but still nothing. Can someone help me? I need to work on it. A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data 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. Anonymous 2022-11-30T09:49:07+00:00 Dear Jessica, We appreciate that you posted back and shared so detailed information with us. And we’re sorry for the late reply. We noticed that you are using Excel 16.66.1 and you are using Microsoft 365 subscription. We have also tested it on our side with the latest version of 16.67 of Excel production version and we can find this option. And we have also tested with 16.66 and we can still find this option. Given this situation, we’d suggest you update your Office to the latest version of Excel 16.67 to check if you can find this option. If not, recently, someone solved the problem via joining into Office insider, we also noticed that you have also tried Office insider again to check if it will help. For your reference: Unable to view "power query editor" on Excel v16.67 for Mac - Microsoft Community If the suggestions above don’t work, we’d also suggest you refer to the suggestion Jim provided, and you can confirm with the other colleagues to check if they have the same problem. If they have same problem, this issue may be related to that your organization has blocked this option for you. And if only your account has this problem, you can also try creating a new user profile on Mac to check if the same problem will occur. If the same problem still persists, given this situation, we do understand the inconvenience caused and apologize for it. Since we cannot reproduce the same situation as yours and only your problem has this problem, this issue may be related to this account and may need to checked from background. The best way to troubleshoot the issue is to report the issue to the related Team. We’d suggest you contact your office 365 administrator to go to Office 365 Admin Center-> Support-> New Service Request, the support engineers there have the correct escalation channel and this is the most efficient way to report such issue. You can refer to this article to check the way how to raise a ticket. Ways to contact support for business products - Admin help . The engineers in related team have higher permission and resources than us to help from background directly. If the scenario above is not consistent with yours, you can also post back and point that. Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well! Sincerely, Sukie | Microsoft Community Moderator 0 comments No comments We appreciate that you posted back and shared so detailed information with us. And we’re sorry for the late reply. We noticed that you are using Excel 16.66.1 and you are using Microsoft 365 subscription. We have also tested it on our side with the latest version of 16.67 of Excel production version and we can find this option. And we have also tested with 16.66 and we can still find this option. Given this situation, we’d suggest you update your Office to the latest version of Excel 16.67 to check if you can find this option. If not, recently, someone solved the problem via joining into Office insider, we also noticed that you have also tried Office insider again to check if it will help. For your reference: Unable to view "power query editor" on Excel v16.67 for Mac - Microsoft Community If the suggestions above don’t work, we’d also suggest you refer to the suggestion Jim provided, and you can confirm with the other colleagues to check if they have the same problem. If they have same problem, this issue may be related to that your organization has blocked this option for you. And if only your account has this problem, you can also try creating a new user profile on Mac to check if the same problem will occur. If the same problem still persists, given this situation, we do understand the inconvenience caused and apologize for it. Since we cannot reproduce the same situation as yours and only your problem has this problem, this issue may be related to this account and may need to checked from background. The best way to troubleshoot the issue is to report the issue to the related Team. We’d suggest you contact your office 365 administrator to go to Office 365 Admin Center-> Support-> New Service Request, the support engineers there have the correct escalation channel and this is the most efficient way to report such issue. You can refer to this article to check the way how to raise a ticket. Ways to contact support for business products - Admin help . The engineers in related team have higher permission and resources than us to help from background directly. If the scenario above is not consistent with yours, you can also post back and point that. Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well! Sukie | Microsoft Community Moderator Jim G • 134K Reputation points • MVP 2022-11-03T15:21:47+00:00 Hi Jessica It looks like Edwine ditched you. Thanks for providing the screen shot of your version and license type. You posted to the Education section of this forum, which leads me to ask if your license was provided by an educational institution. If so, license restrictions imposed by the education institution could be blocking you from having the latest features. Check with the IT department of your institution and ask if your license has restrictions. 0 comments No comments It looks like Edwine ditched you.

Thanks for providing the screen shot of your version and license type. You posted to the Education section of this forum, which leads me to ask if your license was provided by an educational institution. If so, license restrictions imposed by the education institution could be blocking you from having the latest features. Check with the IT department of your institution and ask if your license has restrictions. Anonymous 2022-11-02T21:46:49+00:00 Hi! I'm still waiting for a reply :) 0 comments No comments I'm still waiting for a reply :) Anonymous 2022-10-31T06:01:48+00:00 Hi! Thank you so much for your prompt reply. I attached here the screenshot you asked for. In addition, I already tried to sign out of my Microsoft account and log back in. -Jessica Ettorre. 0 comments No comments Thank you so much for your prompt reply. I attached here the screenshot you asked for. In addition, I already tried to sign out of my Microsoft account and log back in. -Jessica Ettorre. Anonymous 2022-10-31T05:52:40+00:00 Dear Jessica, Greetings, thanks for querying in this forum. We’re happy to help you. We apologize for the inconvenience this issue has caused you! But don't worry. Together we can solve this situation. According to this official article: Import and shape data in Excel for Mac (Power Query) (microsoft.com) , This feature is available to Insiders using either the Current Channel Preview or Beta Channel, running Version 16.64 (Build 22072501) or later of Excel for Mac. It was previously only available to Insiders on the Beta Channel who have joined the Office Insider program . To clearly understand your situation, may I know which subscription/license of Office for mac you are using? Please provide us with the screenshot of About Excel prompt. To get the screenshot, open Excel, go to the Excel menu and choose About Excel. We will help you find a way to figure this out. Meanwhile, as you are preparing to send us your subscription information, please check comments section in this blog: this blog , and also first try to sign out of your Microsoft account. Close it all down. Log back in. Please understand that initial reply may not help. But together we can resolve problems. We will look forward to your reply! Thanks for your patience and understanding! Sincerely, Edwine | Microsoft Community Moderator. 0 comments No comments Greetings, thanks for querying in this forum. We’re happy to help you. We apologize for the inconvenience this issue has caused you! But don't worry. Together we can solve this situation. According to this official article: Import and shape data in Excel for Mac (Power Query) (microsoft.com) , This feature is available to Insiders using either the Current Channel Preview or Beta Channel, running Version 16.64 (Build 22072501) or later of Excel for Mac. It was previously only available to Insiders on the Beta Channel who have joined the Office Insider program . To clearly understand your situation, may I know which subscription/license of Office for mac you are using? Please provide us with the screenshot of About Excel prompt. To get the screenshot, open Excel, go to the Excel menu and choose About Excel. We will help you find a way to figure this out. Meanwhile, as you are preparing to send us your subscription information, please check comments section in this blog: this blog , and also first try to sign out of your Microsoft account. Close it all down. Log back in. Please understand that initial reply may not help. But together we can resolve problems. We will look forward to your reply! Thanks for your patience and understanding! Edwine | Microsoft Community Moderator.