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

5f44ea7e e9ed-4e70-8f0a-fda38eef7de4 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

060d287c fa37-4210-a82b-b723c86bd33b 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

d71f992a cdcb-442c-b236-b4cdaf8a6d4d on 05 Jul 2020 23:52:46

RE: Discard Query Changes

Please Fix This

Power BI User's profile image Profile Picture

5bb57acc 4de8-439d-b195-b0b6f6caab1c 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

14596a46 e31d-44a5-8236-c42d04d3d435 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

7507713c 9f66-446f-bf4d-7f94346a3864 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

a1ec07ff b155-475c-bc3d-b42635f4e25d 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

39c0bd13 f5f6-41f9-a843-43310c839f66 on 05 Jul 2020 23:44:36

RE: Discard Query Changes

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

Power BI User's profile image Profile Picture

98f3102a df4a-4091-81e0-fc25489d7552 on 05 Jul 2020 23:38:44

RE: Discard Query Changes

This is unbelievable. I'm new to PowerBI, and while exploring the editor, closed without saving (didn't even think I changed anything). Now I see "There are pending changes in your queries that haven't been applied" and it will not go away. It MAKES me Apply Changes. Come here to find out the is a FEATURE REQUEST????? To quit without saving is a FEATURE REQUEST? And it's been on the books for YEARS?


Is Power BI a supported product? Is anyone out there?