cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

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

16 REPLIES 16
Helper I
Helper I

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.

 

Not posible if the step to delete is the creation of the table itself.

 

Frequent Visitor
Helper III
Helper III

Power BI is a joke. Something pretty basic and impossible to do. 

This Soution actually wokrd for me. I have deleted all additional steps in Query like Rename Columns/Delete Columns etc and error disppeared. 

Frequent Visitor

 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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors