PowerBI Api Get Access Token

Question

I want automatic login to view power bi reports with iframe in mvc application.

For this, I created an application in Azure AD and gave all read permissions in the delegated permissions.

For this i created a class and get access token. But when i call service with token i get unauthorized error.

The class I created is as follows;

 public async Task<string> GetAccessTokenAsync()
 {
     IConfidentialClientApplication app = ConfidentialClientApplicationBuilder.Create(clientId)
         .WithClientSecret(clientSecret)
         .WithAuthority(new Uri($"https://login.microsoftonline.com/{tenantId}"))
         .Build();


     string[] scopes = new string[] { "https://analysis.windows.net/powerbi/api/.default" };
     AuthenticationResult result = await app.AcquireTokenForClient(scopes).ExecuteAsync();
     Console.WriteLine("token: " + result.AccessToken);
     return result.AccessToken;
 }


 public async Task<string> GetReportsAsync()
 {
     string accessToken = await GetAccessTokenAsync();

     using HttpClient client = new HttpClient();
     client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", accessToken);

     HttpResponseMessage response = await client.GetAsync("https://api.powerbi.com/v1.0/myorg/reports");
     return await response.Content.ReadAsStringAsync();
 }

How can I solve this problem?

Nick A · Accepted Answer · 2024-09-09 20:21:50Z

0

This api call gets the reports from My Workspace:

https://api.powerbi.com/v1.0/myorg/reports

However since the application registration doesn't have a personal workspace, an error is returned.

I recommend using this api call instead:

https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}

This call returns an embed url that can be used to embed the Power BI report directly into your application.

answered Sep 9, 2024 at 20:21

Nick A

1,1202 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PowerBI Api Get Access Token

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related