Expression Error

[excelbytes]

I created VBA code whereby when the user receives a file, it adds a new worksheet, transfers data to that worksheet and creates a table, then saves that file to a specific folder. I have another file that has Power Query steps that will pull the data from all the tables in that folder into one table. Then as new files are added into that folder, I refresh the Power Query table steps and it adds the new file's data to that table. It used to work fine. However, now I get the following error:

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

I've confirmed all the new files have the correct worksheet name and table name, and all the headers in the table match. Any suggestions as to what the "key" is referencing?

 

[Sergius]

Hello! Go through the steps in the Power Query editor. Did you change the file extension?

 

[excelbytes]

Hello! Go through the steps in the Power Query editor. Did you change the file extension?

No, I didn't change the file extension. However, when looking at the Power Query editor, I see the last file I tried to include just shows "Error" across all the columns. When I click on Error, at the bottom in yellow appears the following:

An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=PartsFormTable
Kind=Sheet
Table=

PartFormTable is the name of the worksheet that is created and where the new table, called "PartsForm" is created. I'm not sure that Table=

means.

 

[Sergius]

The name of the sheet or the name of the table did not change?

 

[excelbytes]

I think I found the issue. There was one file in that folder that didn't belong. I removed it and the process works. Thanks for your help.