Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
EricB
New Member

Back or Undo in the BI Query Editor?

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

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

6 REPLIES 6
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
shah_nawazzz
New Member

I'm also facing these issue.

Applied Steps can help but not at all the places.

Phil_Seamark
Employee
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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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.

Anonymous
Not applicable

Not much help for you now I imagine, but if you have the autobackup feature on at least you can limit the damage to the last 10m or so 😉
Good luck.

It is unbelievable that there is no Undo button. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.