Forum Discussion

andrewdun's avatar
andrewdun
Copper Contributor
Sep 13, 2021

Azure Data Factory Excel read via HTTP fails

I am looking to import data form a https://www.environment.gov.au/system/files/resources/79ce6b96-ddb8-4957-87ea-2bf98f89c567/files/abs-waste-data-export-australia-19-20.xlsx 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?

 

No RepliesBe the first to reply

Resources