Azure Data Factory: Link connection Sharepoint

Carlos Colina 46 Reputation points
2020-07-13T08:12:02.213+00:00

Hello,

i'm trying to link in Data Factory a Sharepoint and i have some problems, when i try to copy data i have this 

warning: The access token generated failed, status code: BadRequest, error message: {"error":"invalid_resource","error_description":"AADSTS500011: The resource principal named 00000003-0000-0ff1-ce00-000000000000/sener365.sharepoint.com was not found in the tenant named 1e43f7be-f580-486d-8ff2-d66cc5057ccd.  This can happen if the application has not been installed by the administrator of the tenant or consented to by any user in the tenant. You might have sent your authentication request to the wrong tenant.\r\nTrace ID: 2e5396bf-d060-47b7-b565-1c01558c4700\r\nCorrelation ID: 6942a4d4-33bd-4500-aee1-1e3e0cc193b7\r\nTimestamp: 2020-07-13 08:06:09Z","error_codes":[500011],"timestamp":"2020-07-13 08:06:09Z","trace_id":"2e5396bf-d060-47b7-b565-1c01558c4700","correlation_id":"6942a4d4-33bd-4500-aee1-1e3e0cc193b7","error_uri":"https://accounts.accesscontrol.windows.net/error?code=500011"}. Activity ID: 7ee1064a-cf74-4304-a35a-fafab863bd70.

Note: For the service principal ID i create an app registration an same for Service principal key, but i dont really know if it is correct and is it is linked to sharepoint or if i have to use some service principal ID from Sharepoint.

Thanks.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,827 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,083 questions
0 comments
Accepted answer
  1. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2020-07-13T22:04:28.353+00:00

    Hello @Carlos Colina ,

    Thanks for the question and also for using this forum.

    After reading the question , i was unable to make if you are trying to copy LIST or file from sharepint . Anyways if you are planning on sharepiont list you can use
    https://video2.skills-academy.com/en-us/azure/data-factory/connector-sharepoint-online-list#prerequisites

    or for file

    https://video2.skills-academy.com/en-us/azure/data-factory/connector-sharepoint-online-list#copy-file-from-sharepoint-online

    For the Service prinicipal which you have created it it should have the "SharePoint Online site owner permission" ( this is called out in the above link .

    Please do let me know how it goes .

    Thanks& stay safe
    Himanshu
    Please do consider to click on "Accept Answer"** and **"Up-vote"**** on the post that helps you, as it can be beneficial to other community members

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.