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

Petrut Popescu 6

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!

svijay-MSFT 5,201 Reputation points Microsoft Employee

2021-09-20T09:25:47.97+00:00

Hello @Petrut Popescu

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

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

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.

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.

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.
Petrut Popescu 6 Reputation points

2021-09-20T10:36:06.15+00:00

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!
svijay-MSFT 5,201 Reputation points Microsoft Employee

2021-09-20T12:07:52.857+00:00

Hello @Petrut Popescu ,

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

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

2021-09-20T12:09:47.45+00:00

Yes, I'm selecting the file using Browse.
svijay-MSFT 5,201 Reputation points Microsoft Employee

2021-09-20T13:21:27.25+00:00

Hello @Petrut Popescu ,

Thanks for your response.

Can you please confirm whether the below option is set at your end and is filtered for the .xlsx files
Petrut Popescu 6 Reputation points

2021-09-20T13:24:02.233+00:00

Hello, Thanks for your time investigating this.

This option is not filled out. One more thing I can say is that for a copy activity, the .xls dataset works as expected, but not within the dataflow.
svijay-MSFT 5,201 Reputation points Microsoft Employee

2021-09-21T11:56:22.11+00:00

Hello @Petrut Popescu ,

That's strange. Did you happen to try with a different *.xls file( preferrably 1 - 2 MB small sized file) or in a different Storage container ? Is the issue persistent with a different file across - Then I'd recommend opening a support ticket with Microsoft team to have a closer look at the issue.

1 answer

Petrut Popescu 6 Reputation points

2021-09-21T12:38:04.197+00:00

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! :)
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment