Forum Discussion

Icon for Helper I rank

Helper I

4 years ago

Solved

M code syntax for connecting to Excel files - difference between sheet and table (Navigator step)

Hey all, I have a quite weird question - is there somewhere some documentation, blog, video, or anything explaining M code for connecting to excel? Especially if you want to modify the code for sw...

Tutorial Requests

amitchandak
4 years ago
Draginko , There can be a few reasons

like

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/

https://stackoverflow.com/questions/58420438/how-to-resolve-power-bi-error-the-key-didnt-match-any-rows-in-the-table

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/m-p/155986

Icon for Super User rank

Super User

4 years ago

Draginko , There can be a few reasons

like

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/

https://stackoverflow.com/questions/58420438/how-to-resolve-power-bi-error-the-key-didnt-match-any-rows-in-the-table

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/m-p/155986