Forum Discussion

beeper's avatar
beeper
Frequent Visitor
2 years ago
Solved

Power Query changes are now permanent, how do I prevent this?

It seems my company has updated Power BI and as of the April 2024 version, the behavior of Power Query has changed in a way that is very detremental to my work flow. Since PQ has no undo feature, I c...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
    Greg_Deckler
    2 years ago

    beeper One last step to what Anonymous provides, at that point you can click the Discard changes button to not save your changes.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

beeper One last step to what Anonymous provides, at that point you can click the Discard changes button to not save your changes.

beeper's avatar
beeper
Frequent Visitor
2 years ago

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!