Community
Loading...
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
Windows
Official Microsoft response
Steve K.
Official Microsoft response
2 years ago
Thank 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.

57 comments

You must to comment
Ivan Orava21 days ago
0 reports0
Isaiah Berg4 months ago
0 reports0
Claudia Susana Gonzalez5 months ago
0 reports0
Pavel Recnik6 months ago
0 reports0
Emanuel Guerra6 months ago
0 reports0
Mason Hollister7 months ago
0 reports0
Mohamed Amine Kihal7 months ago
0 reports0
Kunisch, Max8 months ago
0 reports0
Community User1 year ago
4 reports4
Mavis Nightingale1 year ago
0 reports0