none
Power query not showing up in COM add ins RRS feed

  • Question

  • I downloaded power query for 64 bit system but said my excel was 32 so then I downloaded power query for 32. it says it downloaded successfully but it is not listed in the COM add ins. 
    Wednesday, January 18, 2017 4:00 AM

Answers

  • You don't need to install Power Query for a Excel 2016, it comes pre installed. Unfortunately this is a Microsoft naming failure (IMO). On the Data tab, the second group from the left is called "get and transform". This is Power Query. In Power BI Desktop it is called Get Data. So now we have 3 names and everyone is confused :-(

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Wednesday, January 18, 2017 5:25 PM

All replies

  • Have you installed it? What version of Excel are you using? You could check for disabled addins

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Wednesday, January 18, 2017 5:53 AM
  • I have installed it...more than once and it appears in my control panel programs. I am using Office 2016, I am not sure what version of excel. how do i check for disabled add-ins? 
    Wednesday, January 18, 2017 3:19 PM
  • I just figured it out... says there are no disable add-ins
    Wednesday, January 18, 2017 3:20 PM
  • but still no power query tab in the COM add ins. 
    Wednesday, January 18, 2017 4:29 PM
  • You don't need to install Power Query for a Excel 2016, it comes pre installed. Unfortunately this is a Microsoft naming failure (IMO). On the Data tab, the second group from the left is called "get and transform". This is Power Query. In Power BI Desktop it is called Get Data. So now we have 3 names and everyone is confused :-(

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Wednesday, January 18, 2017 5:25 PM
  • Thank you! that must be it. I will uninstall the one that I downloaded. now I need to figure out how to use power query but I will rely on youtube videos for that. 
    Wednesday, January 18, 2017 11:47 PM
  • Yes, there is good material around. I am producing commercial online training but it wont be ready until the end of Q1.  http://exceleratorbi.com.au/course/power-query-excel-power-bi/

    I have a lot of material I have blogged about at my site which is all free of course

    http://exceleratorbi.com.au/category/power-query-2/

    and also stuff I (and others) have posted here 

    http://www.powerpivotpro.com/category/power-query/

    Good luck with it.  Power Query is awesome


    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Thursday, January 19, 2017 7:21 PM