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

[Sanjica]

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

[v-shex-msft]

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

[Sanjica]

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

[v-shex-msft · Accepted solution]

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