"Data, get data from other sources, Microsoft query" is missing from excel menu after 365 update

Question

Hi

After the last update for 365, the option to select:

Data, get data from other sources, Microsoft query

Is not visible.

Has it been moved? Or is there another way to connect?

Answer 1

set

https://learn-attachment.microsoft.com/api/attachments/0cbf0d7c-1360-4475-90f6-7cbaed453a0e?platform=QnA

Answer 2

Dear Es.Engel,

Greetings! Thank you for posting in Microsoft Community.

As per your description, it seems like SharePoint list option is missing in Get Data in your Excel.

I'd like to help you, please let us cooperate and please don't worry, we can work together to narrow down and resolve the situation.

After the update You need to have at least E3 (365 for enterprise) to use this function.

I have found a workaround that works for other users using Power Bi to get the query code, then copy that into a blank query in Excel: In PowerBi: Get Data, More..., from SharePoint Online List Enter the site URL then choose the relevant list from the next screen Transform Data Go to Advanced Editor on the View menu Copy the code from the window In Excel: Get Data, From Other Sources, Blank Query Go to the Advance Editor from the View menu Paste the previously copied code Click Done You should now have the data you require from the list, ready to be transformed prior to closing and loading to Excel.

I hope this helps.

Best,

Shannah

Answer 3

set

https://learn-attachment.microsoft.com/api/attachments/0cbf0d7c-1360-4475-90f6-7cbaed453a0e?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/90310d88-f537-46d9-8a9e-6b2742dc2d57?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

Answer 4

Follow These steps and check.

Answer 5

No, because it said " Microsoft Query could not be started because it isn't installed. You can install Query by running the installation program you used to install office or excel. The Query option is in the Office Tools Category."

How do you do that???