Allow interaction with Excel while in Power Query
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.
Ken Puls
shared this idea
Hi Ken,
Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.
thanks
Ashvini Sharma
Lead Program Manager
Excel
14 comments
-
Ivan
commented
Please make the window non-modal. It makes referring to the worksheet very tedious.
-
Anonymous
commented
This would be really useful.
-
Malcolm
commented
I agree: it slows down work considerably having to keep quitting the query to check the underlying data.
-
Marc Labrie
commented
Great idea Ken...May I also suggest to provide navigation using keyboard shortcut (Ctrl+PgUp, Ctrl+PgDown) while doing do. Thanks!
-
Anonymous
commented
Good idea!
-
Josephine
commented
Agree with the above - so frustrating to not be able to access my worksheet and Power Query at the same time.
-
Anonymous
commented
Please fix this, its really needed.
-
Sean M
commented
This is a must...the current behavior is driving me a little crazy. That and I have issues scrolling in workbooks that have PQ connections, but I'd love this
-
Ghazanfar “GJ” Abidi
commented
This needs to happen. I end up opening another instance of Excel.
-
Ed Hansberry
commented
You also need to be able to save a file (in case of crash) to ensure that you aren't working in Excel for hours on M-Code and lose it all. Having to close the PQ window, then save all changes, then save the file, then reopen the query editor, is absurd.
-
Oz du Soleil
commented
YES! I would love to be able to at least go back and look at the workbook. Just scroll around and select different sheets. That would be a major win.
-
Varghese O
commented
This is really a valid suggestion worth implementing, which would greatly ease moving switching between the windows.
-
Adam Stobbe
commented
1000% Agree - so frustrating!!
Small note that I looked for the uservoice with the most votes on this subject looking for "non-modal" and didn't find this (typo in Ken's post - non-mod*e*l). I hope others are still finding this without mod*a*l in the title.
-
Anonymous
commented
This is a real pain.
I'd like to see this too