Adding user to PowerBI pipeline with a service principal displays a 401 error

[Sen]

The post method is used, which returns 401, but the permissions it needs have already been given

[lmarangio]

Hey @Sen could you elaborate more your question? For instance, can you specify the parameters of your request? How you are authenticating to PBI API? 

[Sen]

Hi @lmarangio ,I use the service principal to obtain a token through the OAuth2 protocol for PowerBI authentication.

Then use Power BI REST APIs to add user to the pipeline user, but the addition fails.
Rest API link:  https://learn.microsoft.com/en-us/rest/api/power-bi/pipelines/update-pipeline-user

[lmarangio]

Are you using the following body in the request?

{
  "identifier": "object_id",
  "accessRight": "Admin",
  "principalType": "App"
}

"object_id" in your case should be "self.sp_id".

[Sen]

yes, refer to Powerbi's REST API, I think it's due to insufficient permissions, but I don't know what additional permissions are needed

[lmarangio]

Hey @Sen, I think that's the problem! You are requesting a token to authenticate as a service principal. But then, reading the body of you request, you are trying to authenticate as a user.

Try to use the following body I alredy reported before:

{
  "identifier": "object_id",
  "accessRight": "Admin",
  "principalType": "App"
}

Try the request with Postman and please post the results here (screenshot of the requeste response)! 

Careful, there is a huge difference between using as "principalType", "User" or "App".