My Problem:
I have a Data Lake Gen 2 Storage Account with an import directory which contains .xlsx files.
Storage Account
Now im trying to create a Dataset pointing to this directory. The Dir will contain multiple .xlsx files and also an archive directory, where processed .xlsx files will be moved to.
I want to point the data set specifically into the import folder and not into the import/archive folder – from what I’ve read i should use a wildcard like *.xlsx in the import dir.
However, I cannot get the dataset to work with the Wildcard, when I point it directly to the FileName.xlsx file its no problem:
working dataset pointing directly to one file
not working using wildcard
what am I doing wrong?
I tried to write the Sheet name and manually and also tried to use the sheet index 0, both give me an error:
ADLS Gen2 operation failed for: Operation returned an invalid status code ‘NotFound’. Account: ‘********‘. FileSystem: ‘‘. Path: ‘ingress/industrysectors/import/*.xlsx’. ErrorCode: ‘PathNotFound’. Message: ‘The specified path does not exist.’.
mariusf is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.