Skip to main content

Power BI

Needs Votes

Discard Query Changes

Vote (436) 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

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

33c29c12 228a-42d4-bbf4-373ccdad09b2 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

867c5338 149f-41e2-b7ef-35ab09745fce 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

f739773f 866a-41a1-9309-35b9a162f1ed 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

6e038945 6ba3-4baf-92fc-4a62f6464ea9 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

2542de55 2bd6-42b2-8bca-1e4522abebc9 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

0eea692e e932-438f-bb82-18f5b2f418aa 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

82cbd145 17f7-49b3-a7d7-974bb7db6b0a 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

Adeany Chappe De Leonval on 06 Jul 2020 00:10:28

RE: Discard Query Changes

Desperately need this option!

Power BI User's profile image Profile Picture

53d2e5a5 cc59-4e37-87aa-13104fc9d938 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.

Power BI User's profile image Profile Picture

c18431f8 150e-41c2-a827-fd6afc7e5337 on 06 Jul 2020 00:07:20

RE: Discard Query Changes

Somebody in the organisation is a 'ecking prick... So many years and no solution. Are you daft, hello?