Forum Discussion
Sequence contains no matching element error
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.
speedramps , check solution on one past issue
solved by re install -https://community.powerbi.com/t5/Desktop/Error-applying-merged-queries-quot-sequence-contains-no-element/m-p/565919
Or you can log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues
2 Replies
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
speedramps , check solution on one past issue
solved by re install -https://community.powerbi.com/t5/Desktop/Error-applying-merged-queries-quot-sequence-contains-no-element/m-p/565919
Or you can log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues
