Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Sequence contains more than one matching element

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?   

4 REPLIES 4
technolog
Super User
Super User

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.

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

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

@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!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.