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

38b028c8 a556-403d-a2e1-188a3a5d1ed4 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

10c96b2c c997-e711-8179-e0071b6ac181 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

4ee0b4f7 a631-46d6-9717-b169886836a3 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

0c98fa5b f18a-4a34-a019-139473b84b43 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

0074d8fc eba5-4dcc-96de-4d3c3109aff7 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

1b346d83 7901-4df8-8bbe-69b2a7d0da5a 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

bf24a05d c97b-46da-8e1f-5b7a9cd9ecf0 on 05 Jul 2020 23:06:25

RE: Discard Query Changes

I REALLY need ths!

Power BI User's profile image Profile Picture

bf24a05d c97b-46da-8e1f-5b7a9cd9ecf0 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

e2e71de8 f987-4f18-8cb3-224f5a31ad33 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?

Power BI User's profile image Profile Picture

1a1b6b76 230d-43a9-87bc-eb031cafd2b0 on 05 Jul 2020 22:37:23

RE: Discard Query Changes

You just remove the steps that you want to discard in applied steps.