Combine Multiple Files in Folder for Power Query

[QQQ]

I am able to combine multiple .csv files from same folder and create query.

When I attempt this it only imports the first excel file.

And when I list all source file names I get [Expression.Error] The key didn't match any rows in the table.

All excel files have identical headers.

[v-caliao-msft]

@QQQ,

I have tested it on my local environment, I can combine all the CSV file with out any issue. Could you please provide us more detail steps, so that we can make further analysis.
https://www.youtube.com/watch?v=pMQK1Zcc9jw

Regards,

Charlie Liao

[QQQ]

I can also combine all .csv files without issue.

But I am unable to combine all .xlsx files without issue.