cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sdarwish Frequent Visitor
Frequent Visitor

Unexpected Error: Sequence contains no matching element

Hello, 

 

I get this error when I try to open a file in Power BI desktop:

 

Unexpected Error: Sequence contains no matching element

 

Is there any way to solve this problem beside sending feedback to Microsoft?

 

Regards,

Salar

12 REPLIES 12
Sdarwish Frequent Visitor
Frequent Visitor

Unexpected Error: Sequence contains no matching element

I recieve an error when I try to open a file in Power BI:

 

powerbi.PNG

Are there any ways to solve this problem beside sending feedback to Microsoft.

 

Regards,

Salar

Moderator v-yuezhe-msft
Moderator

Re: Unexpected Error: Sequence contains no matching element

Hi @Sdarwish,

Do you encounter the error message when opening a PBIX file in Power BI Desktop? Could you please check if the error goes away by uninstalling Power BI Desktop and reinstalling it? Also make sure you install the latest version of Power BI Desktop.

Besides, I will appreciate that if you can share the PBIX file, I will test it in my Desktop.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sdarwish Frequent Visitor
Frequent Visitor

Re: Unexpected Error: Sequence contains no matching element

Hi @v-yuezhe-msft 

 

I’ve been looking into using custom visuals and have been loading the latest available visuals from the site.

I remember that I ran into this issue once last week, but after that the report loaded normally.

Furthermore when I load the file into the online version everything seems to be ok.

So it might have something to do with the custom visuals and I was wondering if I can force Power BI desktop to load the report without loading the custom visuals to test this.

 

one more thing:

I’ve renamed the .pbix file to .zip, removed all the custom visuals from it, saved it and renamed back to .pbix.

After that I could load the report into Power BI desktop.

Therefore somehow there is/are custom visuals that somehow mess up the report.

 

How can I share the .pbix file with you?

 

Thanks!

Moderator v-yuezhe-msft
Moderator

Re: Unexpected Error: Sequence contains no matching element

Hi @Sdarwish,

You can upload the pbix file to OneDrive and share the link here.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sdarwish Frequent Visitor
Frequent Visitor

Re: Unexpected Error: Sequence contains no matching element

Here is the link: https://1drv.ms/u/s!ApYKe40nnrj5hnTiv6GpCumzSXDS

 

Thank you in advance.

Moderator v-yuezhe-msft
Moderator

Re: Unexpected Error: Sequence contains no matching element

Hi @Sdarwish,

I can reproduce the above error when opening your PBIX file. I am afraid that you need to send a frown email using that button over there.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sdarwish Frequent Visitor
Frequent Visitor

Re: Unexpected Error: Sequence contains no matching element

Hello @v-yuezhe-msft,

 

I have already did that. Thank you for your advise.

 

Regards,

Salar Darwish

Highlighted
TalAruety Regular Visitor
Regular Visitor

Re: Unexpected Error: Sequence contains no matching element

 Hi

I had the same issue, and here is what happend:

I work on the same machine with differnet power bi accounts.

The report i tried to open was connected live to a power bi service modle in user a.

i closed the report, opened another one which was associated with user b,

then when i tried to open the report associated with user a, i got this error.

when i opened the report associated with user b, switched account and then opend the other file it worked.

Power bi team- there should really be a more helpful message in this case such as "Cannot sign in to account accont@diomain.com"

and then prompt with a sign in dialog.

Hope it helps

brandonjudge Regular Visitor
Regular Visitor

Re: Unexpected Error: Sequence contains no matching element

Thanks Tal.  Even though I was logged in as the correct user, switching to my other user account and back to the appropriate one resolved the error.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 62 members 923 guests
Please welcome our newest community members: