PowerQuery fix needed! I just want my Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-2134551%22%20slang%3D%22en-US%22%3EPowerQuery%20fix%20needed!%20I%20just%20want%20my%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2134551%22%20slang%3D%22en-US%22%3E%3CP%3EOk%20so%20sorry%20this%20is%20going%20to%20be%20long...%3C%2FP%3E%3CP%3EI%20have%20spent%202%20hours%20with%20tech%20support.%26nbsp%3B%3C%2FP%3E%3CP%3Ebasically%20I%20bought%20ms%20office%20pro%20plus.%20hooray!%20specifically%20because%20I%20needed%20power%20query%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehowever%20the%20download%20page%20for%20microsoft%20says%20that%20if%20I%20have%20office%20365%20I%20should%20uninstall%20it%20before%20putting%20pro%20plus%20on.%26nbsp%3B%20I%20didn't%20think%20I%20had%20365%20so%20I%20download%20and%20everything%20downloads%20%2F%20installs%20just%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20go%20into%20Excel%20options%20menu%20(where%20you%20go%20for%20add%20ins)%20to%20activate%20the%20power%20query%20add-in%26nbsp%3B%20Nothing!%20power%20pivot%20is%20there%20but%20nothing%20else%20even%20close.%20so%20I%20activate%20what%20is%20there%20and%20file%20with%20tech%20support.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20I%20reach%20out%20to%20microsoft%20tech%20support%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewe%20look%20for%20a%20download%20of%20PowerQuery.%20we%20find%20one%20I%20dowload%20it.%3C%2FP%3E%3CP%3EI%20try%20to%20install%20it%20and%20it%20says%20that%20it%20only%20works%20with%20excell%202010%20and%202013%20and%20that%202016%20already%20has%3C%2FP%3E%3CP%3EPowerQuery%20natively%20and%20it%20will%20not%20install%20it%20on%20my%20machine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eturns%20out%20I%20have%20a%20bunch%20of%20previous%20installs%2C%20office%20home%20and%20student%202016%20and%20An%20old%20trial%20of%20365%20(which%20I%20didn't%20even%20know%20was%20there)%20%2C%20as%20well%20as%20the%20new%20install.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20tech%20support%20guy%20and%20I%20uninstall%20all%20the%20other%20old%20installations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewe%20re-%20download%20and%20install%20office%202019%20pro%20plus%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20I%20check%20excel%20%3A%20Still%20no%20powerQuery!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20way%20I%20can%20get%20powerQuery%20for%20office%20pro%20plus%202019%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20Microsoft%20needs%20to%20offer%3C%2FP%3E%3CP%3EA%20free%20download%20%2F%20installer%20for%20power%20query%20in%20ecxel%202016%20and%202019%20because%20many%20of%20the%20official%20downloads%20do%20not%20have%20it!%20I%20downloaded%20direct%20from%20Microsoft%20and%20activated%20and%20everything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2%20hours%20of%20work%20plus%20and%20still%20no%20Power%20Query%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20still%20trying%20to%20fix%20this%20issue%20but%20i%20don't%20know%20if%20I%20can%20do%20that.%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-LABS%20id%3D%22lingo-labs-2134551%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2135155%22%20slang%3D%22en-US%22%3ERe%3A%20PowerQuery%20fix%20needed!%20I%20just%20want%20my%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135155%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F966538%22%20target%3D%22_blank%22%3E%40PleaseFixPowerQuery%3C%2FA%3E%26nbsp%3BPower%20Query%20is%20an%20integrated%20part%20of%20Excel%20since%20the%202016.%20So%2C%20no%20need%20to%20install%20a%20separate%20add-in.%20But%20you%20will%20not%20find%20a%20separate%20Power%20Query%20ribbon%20anymore.%20It's%20part%20of%20the%20Data%20ribbon%20under%20the%20Get%20%26amp%3B%20Transform%20Data%20group.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-transform-in-excel-881c63c6-37c5-4ca2-b616-59e18d75b4de%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-transform-in-excel-881c63c6-37c5-4ca2-b616-59e18d75b4de%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Ok so sorry this is going to be long...

I have spent 2 hours with tech support. 

basically I bought ms office pro plus. hooray! specifically because I needed power query

 

however the download page for microsoft says that if I have office 365 I should uninstall it before putting pro plus on.  I didn't think I had 365 so I download and everything downloads / installs just fine.

 

I go into Excel options menu (where you go for add ins) to activate the power query add-in  Nothing! power pivot is there but nothing else even close. so I activate what is there and file with tech support.

 

so I reach out to microsoft tech support

 

we look for a download of PowerQuery. we find one I dowload it.

I try to install it and it says that it only works with excell 2010 and 2013 and that 2016 already has

PowerQuery natively and it will not install it on my machine.

 

turns out I have a bunch of previous installs, office home and student 2016 and An old trial of 365 (which I didn't even know was there) , as well as the new install.

 

 

 

the tech support guy and I uninstall all the other old installations.

 

 

we re- download and install office 2019 pro plus

 

 

 

 

so I check excel : Still no powerQuery!

 

Is there some way I can get powerQuery for office pro plus 2019?

 

 

  Microsoft needs to offer

A free download / installer for power query in ecxel 2016 and 2019 because many of the official downloads do not have it! I downloaded direct from Microsoft and activated and everything.

 

2 hours of work plus and still no Power Query

 

I am still trying to fix this issue but i don't know if I can do that.

 

 

 

1 Reply

@PleaseFixPowerQuery Power Query is an integrated part of Excel since the 2016. So, no need to install a separate add-in. But you will not find a separate Power Query ribbon anymore. It's part of the Data ribbon under the Get & Transform Data group.

https://support.microsoft.com/en-us/office/get-transform-in-excel-881c63c6-37c5-4ca2-b616-59e18d75b4...