Share via

Sharepoint linked service, error 23201

Smits David 1 Reputation point
2022-07-15T10:42:14.497+00:00

I am trying to setup a linked service in azure data factory for connecting to a Sharepoint site (azure data factory and sharepoint site are on different tenants).
I have followed all instructions as per https://zcusa.951200.xyz/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory.
However when testing the connection I get the following error:
Error code : 23201
Failed to get metadata of odata service, please check if service url and credential is correct and your application has permission to the resource. Expected status code: 200, actual status code: Unauthorized, response is : {"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."}.

Please advice how to resolve this error.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,052 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,004 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,201 Reputation points Microsoft Employee
    2022-07-15T20:37:57.1+00:00

    Hello @Smits David ,

    Welcome to the Microsoft Q&A platform, and thanks for posting your query.

    We apologize for the inconvenience you have encountered.

    I have noticed that a similar issue has been discussed here. Could you please check and see if this helps.

    Here are the two potential issues discussed on this thread.

    1. Could be an issue with Permissions
    2. another reason could be with Disablecustomappauthentication

    In case, If this resolution didn't help, I would suggest opening a support case for a deeper investigation. If you don't have a support plan, please let me know. I can provide you one-time free support request.

    I am looking forward to hearing from you.

    1 person found this answer helpful.

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.