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-luwang-msft]

Hi @speedramps  ,

Someone take the following actions to deal with this question:

Actions taken since this was posted :

- downgraded Power BI Desktop to December 2020 version

This allowed me to make modifications to the query and NOT get the "Sequence... " error message.

- Modified the problem query clicked "Apply & Close" and refresh completed successfully

- Upgraded Power BI Desktop back to Feb 2021 version

- Refreshed data model with no issues and successfull published to workspace

to learn more details ,you can see the below article:

Sequence contains no matching element

Wish it is helpful for you!

Best Regards

Lucien

[amitchandak · Accepted solution]

@speedramps , check solution on one past issue

https://community.powerbi.com/t5/Issues/Cannot-Load-Power-BI-Service-Data-Sources-Sequence-Contains-...

solved by re install -https://community.powerbi.com/t5/Desktop/Error-applying-merged-queries-quot-sequence-contains-no-ele...

Or you can log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues