Excel for Mac Power Query features missing

%3CLINGO-SUB%20id%3D%22lingo-sub-3086514%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%20Power%20Query%20features%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3086514%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20understand%20that%20Excel%20for%20Mac%20now%20has%20Power%20Query%20functions%20%E2%80%93%20however%20it%20appears%20to%20be%20missing%20from%20my%20installation.%26nbsp%3B%20From%20earlier%20correspondence%20I%20had%20thought%20it%20might%20because%20I%20was%20on%20a%20corporate%20managed%20account%2C%20but%20having%20started%20from%20scratch%20with%20an%20installation%20of%20Excel%20from%20my%20personal%20Microsoft%20account%2C%20it%20is%20still%20missing.%26nbsp%3B%20Why%20is%20this%20the%20case%3F%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-01-29%20at%2016.43.09.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343583i42D8E0C667C3DE6D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-01-29%20at%2016.43.09.png%22%20alt%3D%22Screenshot%202022-01-29%20at%2016.43.09.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3086514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3086620%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20Power%20Query%20features%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3086620%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1270269%22%20target%3D%22_blank%22%3E%40sichunlam%3C%2FA%3E%26nbsp%3BIndeed%2C%20Excel%20for%20the%20Mac%20has%20some%20PQ%20functions%20but%20it's%20not%20something%20really%20useful%20yet.%20%26nbsp%3BThat's%20my%20humble%20opinion%2C%20anyway.%20With%20no%20disrespect%20to%20MS%20efforts%20to%20port%20PQ%20to%20the%20Mac.%20Am%20looking%20forward%20to%20the%20day%20that%20PQ%20really%20comes%20to%20the%20Mac.%26nbsp%3BBut%20you%20should%20have%20it%20in%20your%20set-up%2C%20as%20you%20have%20an%20MS365%20subscription.%20Have%20you%20tried%20to%20join%20the%20Insider%20program%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2Fjoin%2Fmac%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Finsider.office.com%2Fen-us%2Fjoin%2Fmac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I understand that Excel for Mac now has Power Query functions – however it appears to be missing from my installation.  From earlier correspondence I had thought it might because I was on a corporate managed account, but having started from scratch with an installation of Excel from my personal Microsoft account, it is still missing.  Why is this the case?  Thank you.

 

Screenshot 2022-01-29 at 16.43.09.png

1 Reply

@sichunlam Indeed, Excel for the Mac has some PQ functions but it's not something really useful yet.  That's my humble opinion, anyway. With no disrespect to MS efforts to port PQ to the Mac. Am looking forward to the day that PQ really comes to the Mac. But you should have it in your set-up, as you have an MS365 subscription. Have you tried to join the Insider program?

https://insider.office.com/en-us/join/mac