error folder

[nicolast29]

Hi

I can resolve the source of error in my Query from folder

Normally my file are same type, but i missed something, and there is not much help with the error code:

An error occurred in the ‘Transform File’ query. DataFormat.Error: La table externe n'est pas dans le format attendu.
Details:
    FRLCAR79GS 11.xls

I try to debug in deleting operation one by one  in the sample file transnformation, but it is the same

I try to debug in deleting operation one by one  in the all files merge , but it is the same (that is the pbix that i publish in the case

When i copy past all the data in one file it works so i wonder how to debug and where is the problem

thanks for helping

https://1drv.ms/u/s!AoqtZHsX4Bzvg_tTnJQU1ToWMdU8oA?e=MMhO8V

https://1drv.ms/u/s!AoqtZHsX4Bzvg_tB2dLNKySqAagAZA?e=JOY5m9

[nicolast29]

thanks

zut de zut for my files

I will  test as youi say

[HotChilli · Accepted solution]

5, 6, 7, 8,9,  11 and 12 are showing errors so there's some sort of corruption (probably in the metadata).

Sometimes this can be fixed by opening the files in Excel and saving them with a different name.