topic Re: Acquired token gives 401 Unauthorized when trying to create DataSet in Developer

Acquired token gives 401 Unauthorized when trying to create DataSet

Anonymous — Thu, 30 Jan 2020 08:41:31 GMT

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(resourceUri, new ClientCredential(ClientID, AppSecret)).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

Re: Acquired token gives 401 Unauthorized when trying to create DataSet

Anonymous — Fri, 31 Jan 2020 08:50:17 GMT

Solved it myself

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

Re: Acquired token gives 401 Unauthorized when trying to create DataSet

Anonymous — Sun, 12 Apr 2020 07:34:49 GMT

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.

Re: Acquired token gives 401 Unauthorized when trying to create DataSet

anjanarja — Sat, 18 Jul 2020 15:24:28 GMT

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

Re: Acquired token gives 401 Unauthorized when trying to create DataSet

visuresh — Wed, 20 Jan 2021 00:47:55 GMT

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?