Tim Graham on 02 Jan 2022 03:44:44
Improve the ability to save work / avoid losing your work when using Power Query online (i.e., query editor for dataflows).
1) Add a "Save Draft" button (or similar) that lets you save what you've done, but NOT force you to exit the query editor. The changes made in the draft would not "go live" until full save and exit from the editor.
2) Add a cancel confirmation dialog so that if you accidentally hit the "Cancel" button, it does not immediately exit you from the query editor without having saved your work (i.e., "Are you sure you want to cancel? Any changes made in this session will not be saved.")
3) Add some kind of option to exit the query editor AND save your work, but NOT run through the query validation process (maybe same functionality as the "Save Draft" idea in #1 above). Sometimes the validation process takes multiple hours to run. Additionally, when the validation is running, add a note to the status window that explains what will happen if you click "Cancel" -- i.e., will it return you back to the query editor with no lost work (yes, it does), or will it cancel everything, exiting you from the editor without saving your work (no, it won't, but it would be nice to know this when you're waiting for it for hours).
Thanks!