Forum Discussion

EricB's avatar
EricB
New Member
9 years ago
Solved

Back or Undo in the BI Query Editor?

Is there a Back or Undo feature in the BI Query Editor?

  • You can use the APPLIED STEPS feature as a form of back/undo as it captures every transform you make by adding a step which you can delete if required.  This doesn't help in every situation.

     

    If you are editing in the Advanced Editor then you can ctrl-z like you can in most text editors

7 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee

    You can use the APPLIED STEPS feature as a form of back/undo as it captures every transform you make by adding a step which you can delete if required.  This doesn't help in every situation.

     

    If you are editing in the Advanced Editor then you can ctrl-z like you can in most text editors

    • brika's avatar
      brika
      Frequent Visitor

      Unfortunately while making some modifications on a step in the middle I let is add a step to view some errors. It deleted the rest of my steps after it. No way to get them back without backing out of the PBIX file and going back to an earlier one. :(

       

      Query editor needs a true undo or at least an option to close it without saving the changes.

      • jbaideme's avatar
        jbaideme
        Advocate II

        It is unbelievable that there is no Undo button. 

  • I'm also facing these issue.

    Applied Steps can help but not at all the places.

  • Anahita's avatar
    Anahita
    Frequent Visitor
    This can be an interim solution while they add undo to query editor! :)
    In Power Query Editor go to Home/Advanced Editor
    There you see the row for #”Removed Columns” = ...
    Find the column you want back and delete it from there
    Click done
    P.S. credit of this solution goes to my mentor Thomas Grogan