Error: Sequence contains no matching element

[Anonymous]

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.

  

[Pbix_is]

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. 

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Appears to be a bug - refer to this

Solved: Sequence contains no matching element - Microsoft Power BI Community

regards

Phil