Forum Discussion
Power Query changes are now permanent, how do I prevent this?
Hi beeper
Thanks for the reply from Greg_Deckler .
You can undo previously taken steps through APPLIED STEPS.
In addition, after my test, if you select NOT NOW, Power Query will close back to the Desktop and will not save the changes.
I deleted the Month Name column, and after I clicked Not Now I returned to the desktop.
This column exists in the desktop unless Apply Changes.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
beeper One last step to what Anonymous provides, at that point you can click the Discard changes button to not save your changes.
Hi beeper
Thanks for the reply from Greg_Deckler .
You can undo previously taken steps through APPLIED STEPS.
In addition, after my test, if you select NOT NOW, Power Query will close back to the Desktop and will not save the changes.
I deleted the Month Name column, and after I clicked Not Now I returned to the desktop.
This column exists in the desktop unless Apply Changes.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Greg_Deckler
Community Champion
beeper One last step to what Anonymous provides, at that point you can click the Discard changes button to not save your changes.
Thank you Anonymous and Greg_Deckler. It's an extra click, but after clicking "Discard Changes" once in back in Power BI, it then undoes all PQ changes as desired. I was confused as this behavior is inconsistent with all other Microsoft products that I've been using for decades. Appreciate the help!
