Power BI

Completed

Discard Query Changes

Vote (451)

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)

Comments (45)

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?

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.

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.

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!