Sequence contains no matching element error

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

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.

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.

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.

Thank you thomasduvivier

Thanks Anonymous, all sorted now!