cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sanjica Frequent Visitor
Frequent Visitor

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

Why am I not able to append my files into one table in Power Query? All of the columns are aligned and in the same format.  Does anyone know what could cause the error "[Expression.Error] The key didn't match any rows in the table"?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @Sanjica,

 

As you said, current power query not contains any functionality to auto fix these issue, you have to manually do them.
Maybe you can submit an idea for add support for auto fix 'key didn't match' issues.

 

Regards,
XIaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Community Support Team
Community Support Team

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

HI @Sanjica,

 

Please refer to below thread who told about same issue.

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

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Sanjica Frequent Visitor
Frequent Visitor

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

Thanks, Xiaoxin. I looked into the thread, and determined that maybe my worksheet names should have been named the same. I would prefer to not have to manually rename each file as I have a lot of them, but at least it works now..

Community Support Team
Community Support Team

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

Hi @Sanjica,

 

As you said, current power query not contains any functionality to auto fix these issue, you have to manually do them.
Maybe you can submit an idea for add support for auto fix 'key didn't match' issues.

 

Regards,
XIaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |