Forum Discussion

elz's avatar
elz
Advocate II
10 years ago
Solved

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
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 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. 

 

clenart's avatar
clenart
New Member
6 years ago

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.