How to access REST end point hosted in APIM using service principal authentication in synapse?

Deba Nayak 61 Reputation points


I am trying to access an API endpoint hosted on Azure APIM using principal service authentication. I have created the app registration, secrets and received the required API permission.

In the REST API linked service I selected the authentication type as Service principal and provided the credentials. I am unsure about the AAD resource, but I am getting a successful test connection.


I am getting successful connections at the DataSource level as well. But when I try to data preview in the activity level, I get the error message "The property 'servicePrincipalId' is invalid or missing."

Not sure what is the issue here. Kindly help!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,791 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,439 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Konstantinos Passadis 13,446 Reputation points

    Hello @Deba Nayak !

    I will suggest to go over here

    Make sure you read and understand the Authentication

    Please mark the answer as Accepted in case you found it helpful!