Sequence contains no matching element error

[speedramps]

Is anyone getting "Sequence contains no matching element" errors in Power BI desktop refreshes?
Is so, which version of Power BI Desktop are you using please?
The forum history says this problem has cropped up before with faulty Power BI desktop releases.
I therefore tested the same PBIX on an old and new version of Power BI Desktop, and sure enough only the new one failed.

[v-lili6-msft]

hi

use march version to have a try. Version: 2.91.701.0 64-bit (March 2021)

https://www.microsoft.com/en-us/download/details.aspx?id=58494

Regards,

Lin

[Anonymous]

Hi, 

Same, I had this yesterday when editing and refreshing one of my reports and I found that the error appeared when unpivoting a table. If I removed this step, the error no longer appeared. I'm not sure why this is happening as it has not happened before on this version of PBI.

[speedramps]

Thanks Samantha_h and v-lili6-msft for the replies.

I will test the March 2021 version and see if the problem persists.

In the meantime I will be interested to hear from anyone who gets the error, to help establish if it is scripting issue or a fault wth Power BI desktop.

[Anonymous]

Hi, we just had this error and the problem was that we had a relation 1 to many (from Dim to Fact) in ACP, but when deploying to PRD there was an issue with the database so the relation got as a many to many. This broke the model and prevented it to load correctly. All in all, I'd recommend you to check you model relations.

[speedramps]

Thank you thomasduvivier

[Anonymous]

Thanks @Anonymous, all sorted now!