Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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.
Power BI is a joke. Something pretty basic and impossible to do.
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.
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 @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
This Soution actually wokrd for me. I have deleted all additional steps in Query like Rename Columns/Delete Columns etc and error disppeared.
Not posible if the step to delete is the creation of the table itself.
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.
Tracy
@elz 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
@elz While not commented on, I do know that any request on the boards does get evaluated if it receieves over a certain amount of votes. These appear to have both met those numbers, hopefully they will get commented on to let use know if/when they will be implemented. Get as much support for the idea from colleagues if you can. I know that the product team watches those request boards for activity.
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |