This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
The Microsoft Query option that used to be under "Get Data/From Other Sources" has disappeared. I can edit existing queries by right clicking on the query table, but I can no longer create new queries without the Microsoft Query option. I have tried repairing Office 365 but it is still not there. I have 64 bit Office. I recently downloaded Power BI desktop and used Power Query, could this have something to do with my Microsoft Query option disappearing from Excel?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This worked for me:
Options > Data > Check the 'From Microsoft Query (Legacy)" box
Then its under Get Data > Legacy Wizards
The Microsoft Query option that used to be under "Get Data/From Other Sources" has disappeared.
thank you so much for this, we couldn't work it out in our office and ms querys are our bread and butter.
thank you again you are our hero
Stupid people. They want to kill client-server architecture to be replaced by Power Query.