Direct Query for Power BI dataset (composite models) - Sequence contains more than one element

Hi, lbr_finvision 

First, you should check if you have updated your desktop version to the newest and if you logged in to the correct account. Then you can try to open pbix2 first and insert the dataset1 into it and find if it can work.

I’ve also searched this error online, here are two cases that may contain a solution to your problem, you can take a look:

https://community.powerbi.com/t5/Desktop/Unexpected-Error-Sequence-contains-no-matching-element/td-p/49722

https://community.powerbi.com/t5/Desktop/Error-Retrieving-Power-BI-Service-sources-sequence-contains-more/td-p/307139

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.