Posted inExcel
Feedback collection
2 years ago
Allow interaction with Excel while in Power Query
Last edited by The Microsoft Feedback Team 2 years ago
Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel. The current behaviour makes it very difficult to do things like the following: -Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to -When we have a static table in Excel and are trying to build a query that lands an output in that shape, we can't hop back and forth and check how close we are. In the current implementation, we must close & load the query, check what we need, then re-open the query. Alternately we need to take a screen shot of the needed, or open a second Excel process in order to allow interaction. None of these are good solutions.
Not right now
WindowsNot right now
Official Microsoft response
Steve K.
Official Microsoft response
2 years agoThank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.
Vote
57 comments