Azure Data Factory Excel read via HTTP fails

%3CLINGO-SUB%20id%3D%22lingo-sub-2744477%22%20slang%3D%22en-US%22%3EAzure%20Data%20Factory%20Excel%20read%20via%20HTTP%20fails%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2744477%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20import%20data%20form%20a%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.environment.gov.au%2Fsystem%2Ffiles%2Fresources%2F79ce6b96-ddb8-4957-87ea-2bf98f89c567%2Ffiles%2Fabs-waste-data-export-australia-19-20.xlsx%22%20rel%3D%22nofollow%20noreferrer%20noopener%22%20target%3D%22_blank%22%3Epublicly%20available%20Excel%20sheet%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Einto%20ADF.%20I%20have%20set%20up%20the%20dataset%20using%20an%20HTTP%20linked%20service%20(see%20first%20screenshot)%2C%20with%20AutoResolveIntegrationRuntime.%20However%2C%20when%20I%20attempt%20to%20preview%20the%20data%2C%20I%20get%20an%20error%20suggestion%20that%20the%20source%20file%20is%20not%20in%20the%20correct%20format%20(second%20screenshot).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20wondering%20if%20I%20may%20have%20something%20set%20incorrectly%20in%20my%20configuration%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adf_screenshot_1.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309958i3D47F8B0752A1CFA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adf_screenshot_1.png%22%20alt%3D%22adf_screenshot_1.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adf_screenshot_2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309959iEC00B058A052B176%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adf_screenshot_2.png%22%20alt%3D%22adf_screenshot_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am looking to import data form a publicly available Excel sheet into ADF. I have set up the dataset using an HTTP linked service (see first screenshot), with AutoResolveIntegrationRuntime. However, when I attempt to preview the data, I get an error suggestion that the source file is not in the correct format (second screenshot).

 

I'm wondering if I may have something set incorrectly in my configuration?

 

adf_screenshot_1.pngadf_screenshot_2.png

0 Replies