"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

I tried adding it but it doesn't stay. It goes away.

Answer 3

FYI when I followed this response and checked the appropriate box, I did not receive the option for Microsoft Query. Instead, I got only the option for Data Connection Wizard (Legacy) to come up in the menu. I ended up enabling all of the options and Microsoft Query finally came up. Not working as intended but able to get by for now.

Thank you for the assistance to those that got me this far!