Forum Discussion
Get & Transform Data - Get Data Options Don't Work
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.
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.
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?
- As far as I know, those shouldn't affect Power Query working whatsoever. I have those installed as well and do not replicate your issues. These (PQ) tools should be installed by default. I'm not even aware of a way for administrators (of Microsoft 365 subscriptions) to remove that functionality.
Because I'm sure any tech support will point you here, I would recommend posting to the below link (TechNet, Power Query forum). Provide a link to this conversation just in case. This is where I'd start going up the tech support chain.
https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery
I know this really isn't much help. If you do find out what's going on, I hope you'll post back here.