Power Query / Edit a query in advanced editor directly in Excel
As a user, allow me to use the power query "advanced editor" directly in Excel's interface so people that know the M language can speed up the process of modifying the queries and see the results without entering the power query editor.
For example, you could clic on Excel Ribbon's:
Data/Get & transform/Show queries
-> right click one of the workbook's queries and there find the option "Advance editor"
-> the advanced editor window would open, without opening the whole Power Query window
-> change the query's code
-> click save and load
-> see the changes without leaving the Excel's interface
Hans Schulze commented
Especially that modifying SQL requires the query to run 3 times. If it takes minutes to run (12 levels of databases) it would save lots of time to edit-n-run. Especially with the above.