SOLVED

Power query for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-3299389%22%20slang%3D%22en-US%22%3EPower%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299389%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20MS%20excel%2C%20the%20GET%20DATA%20power%20query%20button%20missing%2C%20how%20can%20I%20get%20it%20please%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3419837%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3419837%22%20slang%3D%22en-US%22%3E%3CP%3EEstimados%20Parceiros%2C%3C%2FP%3E%3CP%3EEstamos%20engajados%20no%20projeto%20TechRaiz%20Inc%2C%20parte%20integrante%20da%20organiza%C3%A7%C3%A3o%20Microsoft%20Virtual%20STORES%20Technology%20USA%20Inc%2C%20Grupo%20de%20empresas%20de%20Private%20Equity%20Silver%20Laker%20PARTNER%20Startups%20Sem%20fins%20lucrativos%20Incubadoras%20de%20Startups%20Empresas%20do%20Terceiro%20Setor%20Empresas%20de%20Investimentos%20Subsidiarias%20da%20Microsoft%20Corporation%20Empresas%20Parceiras%20da%20Microsoft%20e%20demais%20empresas%20de%20tecnologia%20de%20software%20e%20hardware%2C%20reunidas%20na%20Miss%C3%A3o%20Digital%20do%20NAI.org.us%20Quadrante%20Magico%20do%20GARTNER%20para%20a%20Alian%C3%A7a%20Digital%2C%20pronta%20para%20levar%20o%20computador%20empresas%20de%20tecnologia%20e%20servi%C3%A7os%20privados%2C%20por%20um%20ONE-STOP-SHOP%20Microsoft%20empresas%20Parceiras%20da%20Microsoft%20e%20respectivas%20empresas%20de%20tecnologia%20de%20software%20e%20hardware.%3CBR%20%2F%3EPortanto%20um%20projeto%2C%20web%2Frede%20Node.sj%20Github%20GithLab%20Firedase%20Plone.org%20C%2B%2B%20Cs%20C%23%20Apache%20w3.org%20e%20outros%20programas%20de%20projetos%20de%20rede%2C%20desenvolvidos%20ao%20longo%20de%2025%20anos%2C%20por%20incentivos%20fiscais%20patrocinados%20in%20empresas%20da%20Triplice%20Alian%C3%A7a%20Microsoft%20Yahoo%20e%20AOL%2C%20em%20um%20ecossistema%20de%20redes%20hibridas%20neural%20de%20software%20e%20hardware%2C%20com%20suas%20proprias%20infrastruestrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastruestrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastruestrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrustura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrustura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrustura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastruestrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrustrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20infrastrustrutura%20de%20classe%20mundial%20de%20nuvens%20privadas%2C%20com%20suas%20proprias%20em%20ordens%20de%20magnitudes%20faceis%20de%20alcan%C3%A7ar%2C%20em%20ordens%20de%20magnitudes%20faceis%20de%20alcan%C3%A7ar%2C%20em%20locais%20web%2Frede%20de%20Plat%C3%A2formas%20de%20Lojas%20de%20APP%20API%20ASPNET%20Framework%20especifica%20para%20os%20clientes%20corporativos%20comprar%20e%20ou%20alugar%2C%20infrastruestrutura%20de%20armazenamento%20de%20armazenamento%20redes%20e%20hardware%2C%20referidas%20de%20eventos%20Microsoft%2C%20e%20empresas%20de%20tecnologia%20de%20software%20e%20hardware%2C%20derivados%20de%20aplica%C3%A7%C3%B5es%20web%2Fnetwork%20realizadas%20por%20desenvolvedores%20profissionais%20e%20%C3%AAxecutivos%20de%20ti%20independentes%20no%20MSDN%20MSN%20e%20TechNet%2C%20nas%20gera%C3%A7%C3%B5es%20de%20conte%C3%BAdos%20de%20dados%2C%20inclusos%20em%20programas%20de%20governos%2C%20programas%20academicos%20e%20demais%20programas%20do%20E-Tracker%2C%20orquestrados%20pela%20Microsoft%20PARTNER%20Network%2C%20para%20.com%20objetivos%20e%20finalidades%20para%20%C3%AAntregas%20de%20solu%C3%A7%C3%B5es%2C%20em%20produtos%20e%20ferramentas%20de%20software%20e%20hardware%2C%20para%20o%20IMPULSIONAMENTO%20dos%20Negocios%20Digitais%2C%20bem%20como%20entregas%20de%20solu%C3%A7%C3%B5es%20para%20os%20problemas%20administrativos%20e%20operacionais%20nas%20pequenas%20e%20medias%20empresas%20publicas%20e%20privadas%2C%20microempreendedores%20individuais%20e%20usuarios%20finais%20de%20uma%20internet%20melhor%20mais%20segura%20e%20justa%20para%20todos%2C%20em%20uma%20nova%20era%20do%20trabalho%2C%20flexivel%2C%20digital%2C%20sem%20papel%2C%20segura%20e%20em%20todos%20os%20lugares%2C%20dando%20origem%20%C3%A0s%20novas%20gera%C3%A7%C3%B5es%20de%20empresas%20Microsoft%20100%20%25%20Digital%2C%20formados%20para%20a%20completa%20automa%C4%8D%C3%A4o%20de%20atividades%20administrativas%20e%20operacionais%2C%20por%20interoperabilidades%20de%20trabalhos%20flexiveis.%3C%2FP%3E%3CP%3EObrigado%3C%2FP%3E%3CP%3EJose%20Ramon%20Carias%3CBR%20%2F%3ECEO%20-%20Fundador%3CBR%20%2F%3ETechRaiz%20Inc%3CBR%20%2F%3EMicrosoft%20Virtual%20STORES%20Technology%20USA%20Inc%3C%2FP%3E%3CP%3E%3CFONT%3EKundan1275%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299530%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299530%22%20slang%3D%22en-US%22%3Esure%2C%20I'll%20try%20this%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299511%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299511%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1377630%22%20target%3D%22_blank%22%3E%40Kundan1275%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etry%20to%20uninstall%2Freinstall.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20I%20have%20M365%20subscription.%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%22Adin_Calkic_0-1651341520987.png%22%20style%3D%22width%3A%20590px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651341520987.png%22%20style%3D%22width%3A%20590px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651341520987.png%22%20style%3D%22width%3A%20590px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651341520987.png%22%20style%3D%22width%3A%20590px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368229iD3A01DBB85335A4E%2Fimage-dimensions%2F590x611%3Fv%3Dv2%22%20width%3D%22590%22%20height%3D%22611%22%20role%3D%22button%22%20title%3D%22Adin_Calkic_0-1651341520987.png%22%20alt%3D%22Adin_Calkic_0-1651341520987.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299508%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299508%22%20slang%3D%22en-US%22%3Eappreciate%20your%20help%2C%20but%20it's%20now%20working%20this%20way.%20are%20you%20using%20Microsoft%20365%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299501%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299501%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1377630%22%20target%3D%22_blank%22%3E%40Kundan1275%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20to%20see%20if%20there%20is%20a%20option%20in%20properties.%20If%20you%20can't%20find%20it%20-%20you%20probably%20have%20different%20subscription.%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%22Adin_Calkic_0-1651337668731.png%22%20style%3D%22width%3A%20550px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651337668731.png%22%20style%3D%22width%3A%20550px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651337668731.png%22%20style%3D%22width%3A%20550px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651337668731.png%22%20style%3D%22width%3A%20550px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368226iC328408E90DD0349%2Fimage-dimensions%2F550x417%3Fv%3Dv2%22%20width%3D%22550%22%20height%3D%22417%22%20role%3D%22button%22%20title%3D%22Adin_Calkic_0-1651337668731.png%22%20alt%3D%22Adin_Calkic_0-1651337668731.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%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%22Adin_Calkic_1-1651337675029.png%22%20style%3D%22width%3A%20498px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_1-1651337675029.png%22%20style%3D%22width%3A%20498px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_1-1651337675029.png%22%20style%3D%22width%3A%20498px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_1-1651337675029.png%22%20style%3D%22width%3A%20498px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368227i194926DA04A575FE%2Fimage-dimensions%2F498x355%3Fv%3Dv2%22%20width%3D%22498%22%20height%3D%22355%22%20role%3D%22button%22%20title%3D%22Adin_Calkic_1-1651337675029.png%22%20alt%3D%22Adin_Calkic_1-1651337675029.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Adin_Calkic_2-1651337685298.png%22%20style%3D%22width%3A%20541px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_2-1651337685298.png%22%20style%3D%22width%3A%20541px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_2-1651337685298.png%22%20style%3D%22width%3A%20541px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_2-1651337685298.png%22%20style%3D%22width%3A%20541px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368228i2131ECB117428AF2%2Fimage-dimensions%2F541x499%3Fv%3Dv2%22%20width%3D%22541%22%20height%3D%22499%22%20role%3D%22button%22%20title%3D%22Adin_Calkic_2-1651337685298.png%22%20alt%3D%22Adin_Calkic_2-1651337685298.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESwitch%20to%20all%20commands%2C%20if%20you%20see%20it%20you%20can%20move%20to%20the%20right.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299494%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1370919%22%20target%3D%22_blank%22%3E%40Adin_Calkic%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20response%2C%20I'm%20using%20version%2016.62%2C%20which%20is%20the%20latest%2C%20but%20there%20is%20no%20power%20query%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-04-30%20at%2022.11.21.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-04-30%20at%2022.11.21.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-04-30%20at%2022.11.21.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-04-30%20at%2022.11.21.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368225iFE3E246F94B262F6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-04-30%20at%2022.11.21.png%22%20alt%3D%22Screenshot%202022-04-30%20at%2022.11.21.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3299421%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3299421%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1377630%22%20target%3D%22_blank%22%3E%40Kundan1275%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMake%20sure%20your%20Excel%20is%20up%20to%20date.%20Data%20Query%20should%20be%20in%20Data%20tab.%20see%20below.%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%22Adin_Calkic_0-1651322657558.png%22%20style%3D%22width%3A%20652px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651322657558.png%22%20style%3D%22width%3A%20652px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651322657558.png%22%20style%3D%22width%3A%20652px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Adin_Calkic_0-1651322657558.png%22%20style%3D%22width%3A%20652px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F368207i103C5E5AA0024911%2Fimage-dimensions%2F652x412%3Fv%3Dv2%22%20width%3D%22652%22%20height%3D%22412%22%20role%3D%22button%22%20title%3D%22Adin_Calkic_0-1651322657558.png%22%20alt%3D%22Adin_Calkic_0-1651322657558.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3441430%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3441430%22%20slang%3D%22en-US%22%3EYour%20screen%20shot%20is%20of%20Microsoft%20Excel%202016%2C%20not%20Office%202021%20beta.%20You%20must%20open%20the%20current%20version%20of%20Excel%20to%20see%20the%20PowerQuery%20features.%3C%2FLINGO-BODY%3E
New Contributor

In my MS excel, the GET DATA power query button missing, how can I get it please help

7 Replies
best response confirmed by Kundan1275 (New Contributor)
Solution

Hi @Kundan1275 ,

 

Make sure your Excel is up to date. Data Query should be in Data tab. see below.

 

Adin_Calkic_0-1651322657558.png

 

@Adin_Calkic Thank you for your response, I'm using version 16.62, which is the latest, but there is no power queryScreenshot 2022-04-30 at 22.11.21.png

Hi @Kundan1275 ,

 

Try to see if there is a option in properties. If you can't find it - you probably have different subscription.

 

Adin_Calkic_0-1651337668731.png

 

 

Adin_Calkic_1-1651337675029.png

Adin_Calkic_2-1651337685298.png

 

Switch to all commands, if you see it you can move to the right.

 

 

 

appreciate your help, but it's now working this way. are you using Microsoft 365?

Hi @Kundan1275 ,

 

try to uninstall/reinstall.

 

yes, I have M365 subscription.

 

Adin_Calkic_0-1651341520987.png

 

sure, I'll try this
Your screen shot is of Microsoft Excel 2016, not Office 2021 beta. You must open the current version of Excel to see the PowerQuery features.