Skip to main content
Microsoft Idea

Power BI

Completed

Discard Query Changes

Vote (451) Share
Power BI User's profile image

Power BI User on 30 Aug 2015 08:09:53

The query editor only has two options "Apply Now", and "Apply Later". What if I've messed up my query and never want to apply the changes?

Please bring back the ability to discard changes made during the time the query editor was open

Administrator on 22 Jul 2021 21:39:42

This is available in Power BI Desktop - when you close the query editor and choose not to apply your changes, the yellow bar appears at the top of the canvas and allows you to discard your changes.

Comments (45)
Power BI User's profile image Profile Picture

Balakrishna on 05 Jul 2020 22:37:23

RE: Discard Query Changes

You just remove the steps that you want to discard in applied steps.

Power BI User's profile image Profile Picture

Tracy on 05 Jul 2020 22:28:05

RE: Discard Query Changes

Yes, this is a needed option.

The discard option needs to be added to ALL of the dialog boxes and prompts in power bi desktop, that currently ask to save or apply pending changes.

Power BI User's profile image Profile Picture

RAS on 05 Jul 2020 22:25:18

RE: Discard Query Changes

Agreed this is very needed!!

Power BI User's profile image Profile Picture

Mike Honey on 05 Jul 2020 22:25:10

RE: Discard Query Changes

Yes its crazy that 1 year after GA and we still don't have undo or even Discard in the Query Editor. Instead I have to constantly drop in and out of that window and Save the whole file after each query change, to have a rollback point.

I tend to edit queries in a parallel Excel workbook to avoid this, then copy and paste their scripts across - but that is also painful.

Power BI User's profile image Profile Picture

<Christopher Lamb on 05 Jul 2020 22:16:37

RE: Discard Query Changes

Very important request/feature!!