Azure Data Factory Excel read via HTTP fails

Copper Contributor

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