Forum Discussion
Delete pending changes
Hello,
I've been looking for a way to not apply the pending changes, but haven't had any luck. Is there an option or way to do this?
Any help would be greatly appreciated.
Tracy
Hi elz,
Based on my research, whatever we have done in the Query Editor, the warning "There are pending changes in your queries that haven't been applied" will throw out in the report. Some changes we can find in the Applied Steps, and other changes like rename the dataset will not be listed, so that we are not able to know whether we have performed this operation. If you don't want to apply those pending changes, please close the Query Editor without Apply.
Currently, there is no OOTB feature for us to know pending changes. For this issue, I would suggest you submit a feedback in Power BI Idea forum.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
16 Replies
Hi elz,
Based on my research, whatever we have done in the Query Editor, the warning "There are pending changes in your queries that haven't been applied" will throw out in the report. Some changes we can find in the Applied Steps, and other changes like rename the dataset will not be listed, so that we are not able to know whether we have performed this operation. If you don't want to apply those pending changes, please close the Query Editor without Apply.
Currently, there is no OOTB feature for us to know pending changes. For this issue, I would suggest you submit a feedback in Power BI Idea forum.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu- hi qiuyun,
i have tried closing the query editor without applying the changes . i think this becomes a problem, when you make a change in the query editor, select "close", then go and make changes to a report and only want to save the changes you make to the report. perhaps adding an option to the apply changes dialog box that you get when you save the file, that says cancel pending changes made in the query editor would help.Hi elz,
What we can do currently is to cancel changes, we can click Undo button in Query Editor. But it's hard to find which steps are canceled. So if you have any feedback, you can post it in Power BI Idea forum.
Best Regards,
Qiuyun Yu
Hi,
I can't get rid of "there are pending changes in your queries that haven't been applied".
Because of this error message, I can't upload my data, I am stuck in a endless loop asking me to apply changes, but changes can't never be applied due to an error.
- elz
You can just go to query editor and delete the steps that are additional to the original. Once you do close and apply it won't show to apply pending changes as they are deleted.Hi Ankit,
I guess that would work, but I don't know what changes were made and since then I have saved the file. I think that there should be an option to view a list of the changes and be able to select which changes to delete.
Tracyelz Outside of the steps you may make in altering the data set as Ankit mentions, there is no "version control" built into Power BI at the moment.
There are a couple requests for that functionality, I suggest you add some votes to one or both of these.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9677517-source-control
I download from the service and open the dataset and see the message "There are pending changes in your queries that haven't been applied". If I click apply changes, all the tables in the dataset dissappear. The data set becomes empty.
I was going to start over by opening the mqueries and recreated the data set. But no.
When I right click a table ... and select edit query I get the dialog "No Query Found" , "Please refresh the model to discard any stale data"
The data set it working. I see the data. The data set refreshes in the service. The data set has parameters and is connected to power bi data flows.
My situation was simple: i loaded 2 objects from SalesForce and then tried to load 3 more (due to lack of memory, the action was stopped).
Then i could not for the life of me, delete the tables.
So i deleted all connections that related to those 2 tables, then i clicked Edit Query (from one of the tables i wanted to delete), then on the left hand side you get a list of all the pending queries, and i found the 2 loaded ones and the 3 that stopped. I right clicked on each of them and deselected "Enable Load" and i was prompted with the message that it will not include the tables in the next refresh (i singed Halleluyah)., then i hit Close and Apply, then i clicked apply changes (once i got the yellow message) and behold: they were gone.
So this was the story of my thriller, albeit a simple one (i did not do any connections or editing on them). But disabling the "Enable load" function should work.
