Uploading multiple excel files error -

[aishak12]

Hi All, 

I have 63 excel files in a folder that all have the same format of columns. I am clicking upload > folder and dropping the file path then attempting to combine and load. I am running into this error does anyone know what the issue is?

[v-yiruan-msft · Accepted solution]

Hi @aishak12 ,

You can follow the steps in the following links to combine multiple files in one folder, then check whether it can works or not.

Import Multiple Excel Files From Folder Into One Excel Table or Data Model

How to resolve Power BI error - the key didn't match any rows in the table

If you still get the error, please validate whether data format in every excel file and provide is same just as suggested by @amitchandak . And please provide some sample data(exclude sensitive data) in these excel file and the related applied codes in your Advanced Editor. On the other hand, you can refer the content in the following link to resolve the problem.

Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or ...

Best Regards

[amitchandak]

@aishak12 , seem like one of the files has a problem with data. Is format same in all excel