Error: Sequence contains more than one matching element

[JacquesZA]

Hi,

I see there are a couple of older posts with this error. But no real update or solution.

I am running the latet version of desktop. 

I hade the master model file, with imported data, published. Then had a connected dataset to that model.

Then had made a change by simply adding a new column to the model file, then when I refreshed the connected Dataset file, I am getting this error message. 

Assuming there is some sort of indexing on measures or columns or something, and now the versions are clashing.

Any idea on how to resolve this? 

[JacquesZA]

Could it be when using Tabular Editor on the connected dataset that is perhaps creating this issue?

[Anonymous]

Hi @JacquesZA ,

I can't reproduce your problem, usually when we encounter this kind of problem, we will suggest the user to optimize the report and reduced the rows or roll back to the previous version to see if it works.

Best regards.
Community Support Team_ Caitlyn

[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.