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

jeffrey Weir on 05 Jul 2020 23:59:03

RE: Discard Query Changes

I'm only human. (Some say barely). My tools need to reflect that.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:58:25

RE: Discard Query Changes

I have the same problem, I have a table I want to import. I've viewed "Column Quality" and had no errors however, when uploading it through an error and now cycles with the message...
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number..
The current operation was cancelled because another operation in the transaction failed.
'. Very frustrating!!! Please fix it soon MS

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:57:39

RE: Discard Query Changes

Annoying that we cannot discard or proceed further. Just stuck there.
Please take it up on top priority.
I do not want to start fresh and create 30 pages again be
cause I cannot discard changes.

Power BI User's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:56:23

RE: Discard Query Changes

I don't want to have to go through and try to remember what pending changes I need to discard anymore.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:52:46

RE: Discard Query Changes

Please Fix This

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:51:49

RE: Discard Query Changes

Its been how many years, and microsoft has still NOT FIXED THIS??? Such a simple feature...

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:50:06

RE: Discard Query Changes

A royal pain to not be able to discard changes in the Power BI Desktop client. Here is how I manage this pain....

Under Options, enable "Auto Recovery" and "Keep the last auto recovery version if I close without saving"

Now when there changes that should not be applied do the following (since I screwed up)

1. Close PBI Desktop (click on "Don't Save")

2. Open PBI Desktop (Auto recovery contains some recovered files that haven't been opened. Click on "View recovered files")

3. Auto Recovery - Available Files will list the "Recovered.pbix" file with date and time, select it and click "Close"

4. Auto Recovery says "ARE YOU SURE???"

5. Choose "No, remove these files" (I'm not crazy, YOU are PBI Desktop!!!!)
and click OK.


Power BI User's profile image Profile Picture

aaron on 05 Jul 2020 23:48:42

RE: Discard Query Changes

how is this not upvoted more??? This feature is borderline dumb to not have.

Power BI User's profile image Profile Picture

Jakub Dušek on 05 Jul 2020 23:48:15

RE: Discard Query Changes

Absolutely necessary! It is already available in Excel Power Query, why not in Power BI???

Power BI User's profile image Profile Picture

Michael Coffey on 05 Jul 2020 23:44:36

RE: Discard Query Changes

I'm having this problem to. This is crazy!