"From Microsoft Query" missing from Get Data in Excel Microsoft Released Update v2403 (build 17425.20146 c2r)

Question

Looks like they moved the "From Microsoft Query" option under Data > Get & Transform Data > Get Data > From Other sources, in this version and made no mention of it in release notes that I can see.

I had to get with a user to add custom group and add that functionality back via Excel Options > Customize Ribbon. Even enabling Legacy doesn't seem to restore the same tools, we tried that first and no "From Microsoft Query" option is available.

There anyway that functionality is still around in another place, and we missed it or is it required to do the above steps to get that option back for my users of this build?

Answer 1

Even with the Legacy option on it doesn't seem to restore it, the only way I could find to get it back and its not exactly the same, was to add a custom group to Data tab (we just named it "from other sources" and add the second available From other sources option (From other sources [Get Data From Other Sources]) to the custom group like below.

Trying with what looks like the original From other sources (the one above the highlighted under the choose commands from column if All commands is selected) it doesn't seem to work either, we tried that as well.

Unless it is hidden somewhere else that we are not seeing when enabling legacy, and it doesn't seem like it from the screenshot some else showed, we don't see that option, but we do see Legacy Wizard show up when legacy is enabled just no From Microsoft Query Option like the above screenshot shows. My users already gone for the week, or I'd jump in and grab a couple more screenshots, I can supply next week if needed.

Answer 2

This is bug. I have updated office to the version same as yours. And the "From Microsoft Query" disappeared.

You may raise it to Microsoft.

Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Support team there will have the correct channel and resources to help you investigate more and find what exactly the reason has caused this situation.

Get support - Microsoft 365 admin | Microsoft Learn

Answer 3

https://learn-attachment.microsoft.com/api/attachments/0cbf0d7c-1360-4475-90f6-7cbaed453a0e?platform=QnA"https://answers.microsoft.com/en-us/msoffice/forum/all/powerquery-how-to-merge-tables-with-conditions/0fa2e65c-6999-45ee-8b4f-4fc272f97762?page=2" rel="ugc nofollow">https://answers.microsoft.com/en-us/msoffice/forum/all/powerquery-how-to-merge-tables-with-conditions/0fa2e65c-6999-45ee-8b4f-4fc272f97762?page=2

Answer 4

Check this one, then close Excel and reopen Excel.

Answer 5

I did this. It worked for awhile. Then it was greyed out and unavailable. Then 20 minutes later it was usable and I created two more queries. Then it greyed out again. It's like a short circuit going off and on. Currently the legacy option is still greyed out.