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

Mike 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?

Power BI User's profile image Profile Picture

Dale Cybela on 05 Jul 2020 23:38:21

RE: Discard Query Changes

There are other requests to implement Source Change Control. The basis for some of those is a "true" source control, however some of what they are asking is to "recover" from a mistake (such as this request). The votes for those "true" source control should be "added" to this request as this is a "step" towards the issue.

Power BI User's profile image Profile Picture

Benjamin Abdipour on 05 Jul 2020 23:37:33

RE: Discard Query Changes

It says apply or discard but there's only one button for apply. I don't know what the developers are thinking.

Power BI User's profile image Profile Picture

Barry Seymour on 05 Jul 2020 23:37:17

RE: Discard Query Changes

I get this as well. I connected to our SQL Server database, entered a query, made the mistake of including an ORDER by statement. The query fails, I get the 'there are pending queries' message, but there's no way I can see to FIX or REMOVE the query. It's just stuck. The only way I can find out of it is to close Power BI without saving changes!

This is not acceptable!

Power BI User's profile image Profile Picture

Miguel Cramer on 05 Jul 2020 23:29:36

RE: Discard Query Changes

To Balakrishna : This is the problem. There is no remove/delete steps

Power BI User's profile image Profile Picture

Wyn Hopkins on 05 Jul 2020 23:17:25

RE: Discard Query Changes

This is painful, so straightforward in Excel.

Power BI User's profile image Profile Picture

Alexis Olson on 05 Jul 2020 23:14:49

RE: Discard Query Changes

This is available in Excel. It would be great if Power BI had this functionality as well.

Power BI User's profile image Profile Picture

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

RE: Discard Query Changes

I REALLY need ths!

Power BI User's profile image Profile Picture

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

RE: Discard Query Changes

It is really unbelievable that has been here for 1 year now!

Power BI User's profile image Profile Picture

Allan Bond on 05 Jul 2020 22:54:21

RE: Discard Query Changes

Yes! How hard would it be to add a "Close without saving changes" option?