Solved: Re: [Expression.Error] The key didn't match any ro...

Anonymous · ‎02-21-2018

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"?

Anonymous · ‎03-02-2018

Hi @Anonymous,

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

View solution in original post

Anonymous · ‎02-22-2018

HI @Anonymous,

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

Anonymous · ‎02-26-2018

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..

Anonymous · ‎03-02-2018

Hi @Anonymous,

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