Forum Discussion

baloo's avatar
baloo
New Member
7 years ago
Solved

Getting Expression.Error: after removing 3 columns from excel data source

I have had to do two changes to my PowerBI reports im working on that are causing errors.   Expression.Error: The key didn't match any rows in the table. Details: Key= Item=Table1 Kind=Table T...
Need Help
  • baloo's avatar
    baloo
    7 years ago

    I figured out the problem. Previous versions of excel sheet were being imported as a table. The excel sheet had been converted to a table prior to being prepared as a data source.

     

    That is why I was getting key row errors and table1 errors.

     

    Ctrl + A on entire Excel spreadsheet, convert to table. Save spreadsheet.

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi baloo ,

 

Yu can refer to the cases below:

 

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

 

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

 

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/td-p/16128/page/2

 

https://community.powerbi.com/t5/Power-Query/Expression-Error-The-key-did-not-match-any-rows-in-the-table/td-p/9824/page/2

 

https://forum.enterprisedna.co/t/error-the-key-didnt-match-any-rows-in-the-table/289

 

Best Regards,

Amy

 

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

baloo's avatar
baloo
New Member
7 years ago

Thank you but I have already reviewed those forum posts.