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)
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?
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.
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.
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.
RE: Discard Query Changes
This feature is requested so often, why won't Microsoft listen?
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
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?
RE: Discard Query Changes
Desperately need this option!
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.
RE: Discard Query Changes
Somebody in the organisation is a 'ecking prick... So many years and no solution. Are you daft, hello?