Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error: Sequence contains no matching element

Hi,

 

I had a dataset that was refreshing fine.

I made a few changes in the query editor yesterday and now the following error appears when I try and refresh the report.

I closed down the file and reopened and also restarted my computer.

 

I have never seen this error before so any help would be appreciated.

  

Need Help

2 Replies

  • Pbix_is's avatar
    Pbix_is
    Advocate I
    3 years ago

    Hi, I got this same error today and I tried refreshing table by table in the model - so identified which table was the issue. Then I went to Power Query Editor and created another query same as the trouble query, but from scratch. Deleted the one that was causing the issue, named new one exactly the same, and just joined it in the model as the old one was joined. Now it works.