Forum Discussion
Combine Multiple Files in Folder for Power Query
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.
2 Replies
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=pMQK1Zcc9jwRegards,
Charlie Liao
I can also combine all .csv files without issue.
But I am unable to combine all .xlsx files without issue.
