Sequence found no matching elements

[niravd1992]

Hi Team,

I recently upgraded to Feb 2021 update.

Me and my team are currently facing a refresh issue in PBI. It says "Sequence found no matching elements ".

In my case, the error is specific to two tables in my model which is generated from merge of two other tables.

Source of my table - Sharepoint List , CSV files

We have tried signing in with different users as suggested in one of the posts.

We can't open this file in old versions of PBI desktop as it is incompatible.

Kindly let me know if any other details required.

Requesting guidance on the issue.

Thanks in advance.

[niravd1992 · Accepted solution]

@v-rzhou-msft 

Thanks for the reply. Turns out the error was misleading. It was date format error in some different table. Once I solved, this error went away.

Thanks for ta

[v-rzhou-msft]

Hi @niravd1992 

Does this error show in Power BI Service or Desktop?

Have you changed the elements in data source?

You can try to upload two tables separately without combine.

And check whether they will show error in refresh.

Please check whether your credential is correct or Expired .

Please check whether your Power bi Desktop is the latest version(2.90.1081.0).

You can update your Power BI Desktop by this link: Link. And then try again.

Best Regards,

Rico Zhou

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