HttpRequestFailedWithUnauthorizedError output after Copy Data function when extract data from Sharepoint to adl using data factory

Question

I followed the tutorial from "https://www.youtube.com/watch?v=FFfNu3cI-uw&pp=ygUjZXh0cmFjdCBkYXRhIGZyb20gc2hhcmVwb2ludCB0byBhZGw%3D"
but this error occurred.

"errors": [ { "Code": 22757, "Message": "ErrorCode=HttpRequestFailedWithUnauthorizedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with status code 401 Unauthorized, usually this is caused by invalid credentials, please check your activity settings.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (401) Unauthorized.,Source=System,'", "EventType": 0, "Category": 5, "Data": {}, "MsgId": null, "ExceptionType": null, "Source": null, "StackTrace": null, "InnerEventInfos": [] } ],

Answer 1

Hi Xing Le Lee - Thanks for reaching out over Q&A Forum.

Based on the exception 401 Unauthorized, usually this is caused by invalid credentials, please check your activity settings. To resolve this issue, make sure to pass the correct credentials in the activity settings.

Request you to please review the below documentation once:

https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online

Apart from this, you can also take a look at the below previous Q&A posts regarding similar error and action plans

https://learn.microsoft.com/en-us/answers/questions/1382525/data-factory-http-copy-activity-returns-error-when

https://learn.microsoft.com/en-us/answers/questions/999634/copy-files-from-sharepoint-to-azure-datalake-using

Hope this helps!

Please let us know if you have any further queries. I’m happy to assist you further.

---

Please "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.