Copy data from website to Azure Blob

Pandey, Aman 6 Reputation points


Thanks in advance!

I am trying to copy data from website to Azure blob using copy function in ADF. I am getting the below mentioned error.

Link for file:

File is a excel.


Operation on target Copy data1 failed: Failure happened on 'Sink' side. ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server:Unable to connect to the remote server,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=Unable to connect to the remote server,Source=System,''Type=System.Net.Sockets.SocketException,Message=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond,Source=System,'

Can you suggest me what to do to resolve this error?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,909 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,306 Reputation points Microsoft Employee

    Hi @Pandey, Aman ,

    Welcome to Microsoft Q&A Platform. Thank you for posting query here.

    l tried to Copy file from below link to Blob and it was working perfectly fine. You need to consider using HTTP connector type dataset in Source tab of Copy activity as your link is going to download a file.

    HTTP connector is generic to retrieve data from any HTTP endpoint, e.g. to download file.

    Please check below detailed steps of implementation.

    Step1: Copy activity, source tab select a dataset which is HTTP connector type with binary format.


    Step2: Copy activity Sink tab select a dataset which is Blob connector type with binary format and give file name inside your dataset as per your requirement. Here I gave name to my file in sink as excelfile.xlsx


    Step3: Copy activity executed Successful.


    Hope this will help. Please let us know if any further queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators