Forum Discussion

Post Partisan

1 year ago

Solved

How do I fix this error?

How do I fix this error?

lbendlin
1 year ago
https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-error-in-power-query-in-power-bi-or-excel/

4 Replies

GiuseppeMR
Frequent Visitor
1 year ago
Hi ,
The second step "navigation" tries to import the sheet "extract" of the source excel.
Check if this sheet exists.
- Rnaval
  Post Partisan
  1 year ago
  Yes, it does exist.
lbendlin
Super User
1 year ago
https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-error-in-power-query-in-power-bi-or-excel/
- Rnaval
  Post Partisan
  1 year ago
  Could this error be caused when it finds blank values in the field CPE?

Related content