Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Acquired token gives 401 Unauthorized when trying to create DataSet

Hi

im building an app to push data to a dataset in Power Bi

 

the token i got from azure does not seam to have te persissions i gave til ap in "app registrations"

the code om using to acquire the token is 

 

string resourceUri = "https://analysis.windows.net/powerbi/api";
string authorityUri = "https://login.windows.net/common/";
           
AuthenticationContext authenticationContext = new AuthenticationContext(authorityUri);
var AuthResult = authenticationContext.AcquireTokenAsync(resourceUrinew ClientCredential(ClientIDAppSecret)).Result;
 
return AuthResult.AccessToken;

and the permissions that is grated in azure ad

but when i try to create the dataset it gives me an 401

i can create the dataset when i generate the token for a user with powershell but not with the token generated from client_id and client_secret

 

Hope you can help

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Solved it myself 

     

    App registration (service principal) needs to be a member of a Security group

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Solved it myself 

     

    App registration (service principal) needs to be a member of a Security group

    • Anonymous's avatar
      Anonymous
      Not applicable

      Can you tell me, how exactly you have added the application security group.

      In Roles and administrator i have added the below role, But still i am getting the error.

       
       

    • anjanarja's avatar
      anjanarja
      New Member

      Can you please explian or direct how the service principal added to security group

    • visuresh's avatar
      visuresh
      Icon for Microsoft Employee rankMicrosoft Employee

      I am facing same issues.  Could you please explain the solution? I dont understand how App registration can become a service principal? which service group should that be added to?