question

PetrutPopescu-4987 avatar image
0 Votes"
PetrutPopescu-4987 asked PetrutPopescu-4987 answered

Azure Data Factory - Data flow - error when using .xls as source

Hi.

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?

Thanks!

azure-data-factory
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @PetrutPopescu-4987

I did a quick check at my end and 'xls' format is working fine at my end.

133571-image.png

The below is the dataset configuration I had. If possible, request you share your configurations.
133564-image.png

In my test scenario - I was using the Source Type as Dataset in the data flow properties. Please let me know if there is any change in this.
133527-image.png

The error : Path does not resolve to any file(s). Please make sure the file/folder exists and is not hidden. - usually occurs when there is incorrect file path.

133573-image.png

Are you using any dynamic content to generate the path to the file? Came across this post discussing about a similar issue and the below is the solution.

133437-image.png


0 Votes 0 ·
image.png (33.2 KiB)
image.png (25.0 KiB)
image.png (21.8 KiB)
image.png (23.4 KiB)
image.png (9.7 KiB)
PetrutPopescu-4987 avatar image PetrutPopescu-4987 SathyamoorthyVijayakumar-MSFT ·

Hi,

Short question: Have you tried to Data preview?

The connection is successful on my end also if I test connection, but it fails when I run it:

Error
Operation on target dataflow1 failed: {"StatusCode":"DF-Executor-InvalidPath","Message":"Job failed due to reason: Path does not resolve to any file(s). Please make sure the file/folder exists and is not hidden.","Details":""}

I'm not using any dynamic content.

This is the strange thing, because if I use .xlsx, with the exact same path, it works.

Should I provide you some other infromation that could help?

Thank you for your time!

133566-untitled1.png


133529-capture2.jpg


133584-capture3.jpg


133585-image.png


0 Votes 0 ·
untitled1.png (22.5 KiB)
capture2.jpg (34.4 KiB)
capture3.jpg (27.8 KiB)
image.png (52.7 KiB)

Hello @PetrutPopescu-4987,

Thanks for getting back. Yes,I 'm able to see the data preview.

133604-image.png


Can you please confirm when you click on the Browse - Are you able to find & SELECT the .xls file?

133599-image.png

133547-xls.gif


0 Votes 0 ·
image.png (51.5 KiB)
image.png (17.6 KiB)
xls.gif (474.3 KiB)
Show more comments

1 Answer

PetrutPopescu-4987 avatar image
1 Vote"
PetrutPopescu-4987 answered

Thank you for your suggestion.
After some testing with versions of the .xls file (less columns, less rows, different file name), I've found the problem.
Seems that the underscore "_" from the beginning of the file name is causing this behavior.
I've tried different file names, but once I insert the underscore at the beginning, it crashes.

Thanks for your support! :)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.