Happening to me also with the June 2020 release. Could we please get a fix for this other than having to "rebuild" our model?
@juan_pablo : I understand. We also had to fix this issue in a report with almost 300 measures, 50 calculated columns and more than 30 tables. We had to do this, because it's a report which we've build for a client and we weren't able to apply any changes anymore in the report due to this bug. Support became impossible. It was a lot of work, but currently the only option. I hope a fix will be released for you soon, but keep in mind that it's possible that you will run into the same problem as we had, namely: not being able to apply any changes in the Power Query editor.
Try following solution
Download the latest June 2020 build (version: 2.82.5858.961). If the issue still exists, try the following:
Hi @parry2k thanks for your reply.
I just installed the last versión and the issue continues.
There's no "Discard Changes" option. If you refer to the "X", after clicing it, nothing happens and the warning appears again.
There are no stale tables, in fact the report works fine and it succesfuly updates all the tables, so I can't follow your steps.
@juan_pablo thanks for the feedback. So seems like you haven't turned on enhanced metadata which is ok. So question is, after you click x, does this issue pops back again or it is fixed? That's something not clear from your reply.
@parry2k - That appears to have worked, thanks! What I did notice is that the table giving me problems had previously been given a description (in Query Editor, Properties) but that it was now blank. Put the description back in and the "pending changes" message disappeared after doing a "Close and Apply". FWIW, about two weeks ago, I noticed that after loading a new version of MS PowerBI, all my query descriptions had multiple repeated descriptions within them.
FWIW, I don't see how we can mark something as a solution. Used to be able to do that but no longer appears as an option.