Forum Discussion
andrewdun
Sep 13, 2021Copper Contributor
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