Dismiss Thumbs.db file when "Get Data" from a folder

[m_arias]

Hi,

Following error show up:

An error occurred in the ‘Transform File from US_1’ query. DataFormat.Error: External table is not in the expected format.
Details:
Thumbs.db

Is there any way to dismiss the Thumbs.db files once the data is extract from a folder.

I am unable to see the files and do not have admin access to change the set up of the computer so it doesnt create this type of files (Thumbs.db)

Thanks.

[v-jiascu-msft · Accepted solution]

Hi @m_arias,

You can add one more step before combining the files. I think it's good to filter them by extension. Please refer to the snapshot below. 

Best Regards,