How to undo the deleted "Applied Steps" in query settings?

[Premkumar]

 Hi Masters!!

I have 200+ columns which are null.  I want to delete that column while doing that, I mistakenly deleted the "Applied steps".  So now I need to redo the steps.  Anyone is there to help me out??

[Anonymous]

Hi friends,i need  redo option is avalible in power query,

i mean if deleted power query step in applied steps in need to undo or recover in applied steps .is it possible recover the applied step.please update me.

[v-ljerr-msft · Accepted solution]

Hi @Premkumar,

There is no Undo option in Query Editor currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. 

Regards

[Anonymous]

Hello,

I am not sure if this helps but I was able to retrieve my columns deleted by mistake.  Under "applied steps" there should be "Removed Other Columns".  If you right click on that, then choose Edit settings, you should get a pop-up that reads:  Choose Columns.  In that box, I just selected all the columns I did want on my query and clicked "OK" at the bottom.  Boom, they reappeared!

Good luck!