Odata to query DataVerse Data

Bipin K PANDAY 0 Reputation points
2025-01-21T09:22:41.84+00:00

i am getting this below error while i am trying to use Odata Linked Services -
Failed to create odata connection to RequestUrl.

Failed to get access token by using service principal. Error: invalid_resource, Error Message: AADSTS500011: The resource principal named 18778c18-0d64-4237-b9fa-35139565e3c9 was not found in the tenant named HSBC. 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. Trace ID: 65991ef1-f937-429e-b2f2-c9d3e4750700 Correlation ID: a19df1af-7d66-4d69-9744-31391beec53a Timestamp: 2025-01-21 09:18:51Z .

AADSTS500011: The resource principal named 18778c18-0d64-4237-b9fa-35139565e3c9 was not found in the tenant named HSBC. 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. Trace ID: 65991ef1-f937-429e-b2f2-c9d3e4750700 Correlation ID: a19df1af-7d66-4d69-9744-31391beec53a Timestamp: 2025-01-21 09:18:51Z

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

1 answer

Sort by: Most helpful
  1. Ganesh Gurram 3,765 Reputation points Microsoft Vendor
    2025-01-22T10:03:32.0666667+00:00

    @Bipin K PANDAY

    Cause for this error: The SharePoint Online List uses ACS to acquire the access token to grant access to other applications. But for the tenant built after November 7, 2018, ACS is disabled by default.

    User's image

    Recommendations:
    You need to enable ACS to acquire the access token.
    Please refer to the following documentation for more details:
    Connection failed after granting permission in SharePoint Online List

    I hope this information helps.

    Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

    Thank you.

    0 comments No comments

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.