Power Query Editor Error transform file

[TomStaps]

Hi,

I added three tables from different Excel files via the folder option in Power BI.

I received an error messages. I can't find out what is wrong and why this is happening.

Can somebody provide help?

In a later stage every week one table needs to be added. This will always come from a new Excel.

[rajulshah]

@TomStaps 

Is the structure of all 3 files same?
You can try to export all 3 of them separately and try to see the difference is there is any.