Expression.Error: The key didn't match any rows in the table

[yansong]

Hi everyone,

i have built a power query on excels by using load from folder. Now i have dropped new excel to the folder. I have run into expression error message.

Expression.Error: The key didn't match any rows in the table.

Details: Key=Record

Table=Table

I think this could be caused by two potential changes. One is I change the table name in excel. The other one is there are additonal two columns added to the table.

Does any one know how to fix it? I really apprecite it. 

[ImkeF]

Please post sample data or at least the M-code from the advanced edtior and upload screenshots from where the error-message pops up.

[yansong]

Here is the error message. I believe when i setup power query by using loan from folder, one of my table in CSV file named LNMSTR_063018. Since then when I drop in more CSV files, the tables are all named LNMSTR_063018. I change them to LNMSTR instead. I don't know if this will casue any error. That's one thing. The other thing is we also added two addtional coluns to LNMSTR table after I setup the power query. I am not sure if this is also the problem. Thank you.

[v-piga-msft]

Hi @yansong,

Have you solved the problem?

If you have solved, could you please share the solution or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, you could have a reference of the two similar threads below which have been solved.

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

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

Best  Regards,

Cherry

[ImkeF]

The error message indicates that the query doesn't find something.

But without any code I cannot help you further here.