I have two excel files in a Azure blog storage, in the same container (one .xls and one .xlsx).
Both file have the same data and schema. When I use the .xls as a source in a Data Flow, I get this error "Path does not resolve to any file(s). Please make sure the file/folder exists and is not hidden."
When using the .xlsx, it works fine.
The path is identical both on the xls and xlsx, only the name of the files differ. Also Preview Data works on the Dataset level, even the number of columns are shown in the Source activity of the data flow.
Do you have any idea how can I fix this?