Sequence contains more than one matching element

[BPike]

Hi All!

After yesterday's degradation, ALL of our composite models (even files that haven't been touched in weeks) are throwing the above error when attempting to refresh in PowerBI Desktop. Our composite models are connected to PowerBI datasets + SQL. 

[technolog]

In my case, I just found one of the freshly added measures via Tabular Editor that was breaking the update. Removed it from the report. Added it again with a different name and everything worked.

Finding that measure was a matter of successively deleting measures until the update worked.

Also from the recommendations I've seen:

Check for Duplicate Elements: Ensure that the data or elements you are querying do not contain duplicates when they are not supposed to. This is often the case when you expect a unique identifier but find multiple entries with the same identifier.