Forum Discussion

nguidoux's avatar
nguidoux
New Member
1 year ago

Add Connection Role Assignment to ServicePrincipalProfile type

According to the add connection role documentation it looks like the ServicePrincipalProfile type should be able to be added to a connection with a role. https://learn.microsoft.com/en-us/rest/api/f...
Need Help
tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

I guess you are trying to add an SPN to a gateway connection by calling an API. 

 

If yes, then please check whether you have sufficient permissions to do so, as per the documentation, these permissions are needed : "The caller must have UserWithReshare or higher role on the connection or be an Adminon the gateway that's bound to the connection."

 

Once you get permissions run the below call

API End point - POST call

https://api.powerbi.com/v2.0/myorg/me/gatewayClusters/<GatewayClusterID>/datasources/<ConnectionDI>/users

Body 

{"identifier":"3d57a533-0719-4528-9d32-7f62c153acb8","datasourceAccessRight":"Read","emailAddress":null,"role":"User"

 

 

 

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!
nguidoux's avatar
nguidoux
New Member
11 months ago

I'm trying to add a ServicePrincipalProfile to a Databricks connection. The Service Principal I'm making the call with is an Owner on the connection.

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    11 months ago

    nguidoux 

    As far as I know, this API works with on prem gateway connection only. It will work for Source Cloud Connections or SCC.
    Not sure if there is any such API available to do so.