Skip to main content

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

Rose Ventura on 25 Oct 2021 19:25:36

RE: Discard Query Changes

This is so frustrating. I have uninstalled/reinstalled Power BI Desktop 4 times on my laptop and I keep getting the same errors. I would think that doing a clean install would solve the issue. I'm having this problem with every single PBIX file and I cannot, at this point, even create a NEW PBIX. I'm an totally dead in the water!

What NOW, Microsoft????

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:55

RE: Discard Query Changes

I keep getting this message in error. It seems especially problematic with the June 2020 release. All I am doing is changing a the datatype on a field and this pops up and I can't get rid of it. Anyone else?

Power BI User's profile image Profile Picture

Parker Smart on 06 Jul 2020 00:13:50

RE: Discard Query Changes

Let's say... For instance... That I'm working on a PowerBI report and I have refreshed the ENTIRE thing and I'm good (roughly 40 queries). THEN I'm adding a valid query and making changes, and one of the DBA's needs to refresh the database. My view or stored procedure is no longer there. I'm totally stuck, because I can't redeploy my resources until other databases have gotten refreshed as well. I LITERALLY can't continue on ANYthing else until that sProc is back in place and I complete that refresh. This is utterly broken.

Power BI User's profile image Profile Picture

Paul Galjan on 06 Jul 2020 00:13:50

RE: Discard Query Changes

Kind of crazy this isn't supported yet. The "workaround" doesn't address tables deleted in error. Without an autosave, this is a huge gap. Implementing it would save thousands of developer hours every year.

Power BI User's profile image Profile Picture

Dan Nichols on 06 Jul 2020 00:13:15

RE: Discard Query Changes

The inability to roll back to the prior iteration of the query before the change that broke things is a fundamental developer feature - and I'm not a Developer. How do I remember precisely what the last change to the code (applied steps or 'M' code) was? If the breakage is data-caused, how do I revert back to a state where I can redesign the query? PowerQuery debugging options are not good enough.

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:04

RE: Discard Query Changes

This feature is requested so often, why won't Microsoft listen?

Power BI User's profile image Profile Picture

Bogdan Cojocaru on 06 Jul 2020 00:11:00

RE: Discard Query Changes

Hy this is a solution that worked for me:

You must go to query editor and delete the wrong query from there,

https://community.powerbi.com/t5/Desktop/Please-apply-or-discard-the-pending-query-changes-and-then-try/m-p/574107#M271209

Power BI User's profile image Profile Picture

Susan on 06 Jul 2020 00:10:35

RE: Discard Query Changes


Discard Query Changes: This is horrible...If there is an issue with your query, you are screwed. You guys need to fix this issue. If my computer crashes and you have to recover your file. Once again it tries to run all the queries, How many times I had to start over because you couldn't provide this very basic step. I think a high school dev could figure out a solution. I loss hours of work because of this issue. You changed the interface which was not necessary, but a simple fix to make things better isn't done. Are you trying to frustrate people?

Power BI User's profile image Profile Picture

Aarti Laddha on 06 Jul 2020 00:10:28

RE: Discard Query Changes

Desperately need this option!

Power BI User's profile image Profile Picture

Tuve Hammer on 06 Jul 2020 00:07:47

RE: Discard Query Changes

Got into this endless loop by renaming a table inside "Edit Query". Shouldn't have done that. Now I can't undo the rename, can't drop the table, can't Not Apply. Can't do anything. Have not backup of my report either so I will probably loose a days work when recreating the whole report.