Sequence contains more than one matching element

[Anonymous]

I am trying to refresh a mixed model.   Some tables from Import mode, and a dataset.    When I refresh, I get this error: 

Sequence contains more than one matching element.   There are some old posts about this but nothing definitive.  

Does anyone know a)  what causes this  and b)  how to fix it?   

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

[Anonymous]

Hi @Anonymous,

Can you please share some more detailed information to help us clarify your scenario? It is hard to troubleshoot from your description. (e.g. data source type)

How to Get Your Question Answered Quickly

BTW, what version of power bi desktop are you worked on, have you try to use the last version desktop to test?

Regards,

Xiaoxin Sheng

[Anonymous]

I have found the answer on a very old post in this forum.    I think it is a bug that MS needs to fix.   The problem occurs when you have a trendline in a chart, and put something like Q1 - 2015 (text) on the x axis.   Putting text, instead of numeric values, will cause the NaN issue.    And the "bug" is that just taking off the text field, and replacing it with a purely numeric value does that make the issue go away.  It persists on that chart and you have to just recreate it.    Test for yourself.  

Chart data contains not a number (NaN) values - Microsoft Power BI Community

[alicia_pbi]

@Anonymous I ran across this issue today and I was last able to refresh my report late last week.  Can yu please confirm which visual you updated?  Is it the "Line and Clustered Column Chart"? or were you using trendlines within the Analytics field in the Visualizations pane?

Thanks!