Forum Discussion

AOM_LV's avatar
AOM_LV
Copper Contributor
Apr 25, 2020

Get & Transform Data - Get Data Options Don't Work

When I click on the Data Menu >> Get Data and then click on any of the From File options, nothing happens. Nothing comes up at all. Similar issues with every option in the menu accept the From Other ...
excel
office 365
Zack Barresse's avatar
Zack Barresse
Iron Contributor
Apr 26, 2020

AOM_LV 

You won't see Power Query as an add-in because it hasn't been for some years now, it's baked right into the application. You see it on the Data tab in the 'Get & Transform Data' group of commands. Since you see those ribbon controls, you have Power Query. It's confusing since it actually started as an add-in originally.

 

To your question, perhaps you don't have MS Query installed? That would be the first thing I would check. To check this, go to your Contol Panel > Programs and Features > right-click Office and select Change > Select Add or Remove Features, make sure MS Query is there. I'm honestly not sure where to go from there. A cursory web search didn't turn up much else than checking if it was installed and forcing updates. My over-arching question is: why do you even want to use MS Query with so many other amazing tools at your fingertips??

  • AOM_LV's avatar
    AOM_LV
    Copper Contributor
    Apr 26, 2020
    That's just it.
    ALL the other tools in that menu don't work.
    ONLY MS Query does. I want to use the other tools however none of them work.
    I've uninstalled and reinstalled office 365 too.
    I'm on Windows 10.
    • Zack Barresse's avatar
      Zack Barresse
      Iron Contributor
      Apr 26, 2020

      AOM_LV That is strange indeed. The only other thing I would try, although I've only heard of this as an issue and never seen it first hand, would be to try opening a blank query in different file formats. I'd guess it wouldn't work no matter the file type (xlsx/default, xlsm, xlsb). If that fails, the only things I can recommend are:
      https://support.office.com/en-us/article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

      https://support.microsoft.com/en-us/help/929135/how-to-perform-a-clean-boot-in-windows

      https://social.technet.microsoft.com/Forums/en-us/home?category=officeitpro&filter=alltypes&sort=lastpostdesc

       

      This certainly sounds like a technical issue. My dealings with these sort of things in the past has been to more or less remove Office completely, including some registry settings for saving login information (Office trying to be helpful) and do a full clean install. I'm not sure how much further help I'll be here.

      • AOM_LV's avatar
        AOM_LV
        Copper Contributor
        Apr 27, 2020

        Zack Barresse 

        Steps 1 and 2 already done. Still not working.

         

        I should also add that I have multiple editions of the following installed:

        • Visual Studio 2008-2019
        • SSMS 18.5
        • SQL Server DataTools/BIDS from 2008 - 2019

        I mention this because while the GetData options don't work, Import Wizard in the Power Pivot windows pulls up wizards that look like the SQL Server Import Data Wizard windows.

         

        Is there anything in the Office Subscription type that would affect this?

Resources