Activities of "Sagar.chinna"

We have application server(UI ABP Application) and Authorization Server(Another ABP Application) Here we have Maintaining only user logins) For integrating Single Sign On (SSO) and Power BI Embed Using Azure AD.

below is the Application flow

Thanks

Hi Anjali,

Thank you.

Now it is working fine with Claim Transformation changes. But if we are switching account using linked account then token not able to generate.

Hi,

Given the access as requested. please check.

Hi,

You can download the source code using the given link

Hi Anjali,

I have added only scope and removed line "GetClaimsFromUserInfoEndpoint" as suggested in https://support.abp.io/QA/Questions/5720/PowerBI-Embed-access-token-issue-with-ABP

After doing the changes I am unable to login to the ABP Application.

I have tried the code but no success.

If we remove the power BI Scope then able to login but "AUD" claim empty and unable to embed power BI

Token Details:

We wish to get the access token for Power BI embed.

Regards, Sagar

Hi team, Can i get any update on this issue.

Regards, Sagar.

• ABP Framework version: v5.3.4
• UI Type: MVC
• Database System: EF Core (SQL Server)
• **Tiered (for MVC) : yes
• Exception message and full stack trace:
• HttpRequestException: Response status code does not indicate success: 401 (Unauthorized). System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode() Microsoft.AspNetCore.Authentication.OpenIdConnect.OpenIdConnectHandler.GetUserInformationAsync(OpenIdConnectMessage message, JwtSecurityToken jwt, ClaimsPrincipal principal, AuthenticationProperties properties) Microsoft.AspNetCore.Authentication.OpenIdConnect.OpenIdConnectHandler.HandleRemoteAuthenticateAsync()
• Steps to reproduce the issue:

Now we are doing it in MVC ABP 5.3.4

We are trying to get the access token for Power BI API token.

adding scope for https://analysis.windows.net/powerbi/api/.default having issue. we have taken reference : https://support.abp.io/QA/Questions/5720/PowerBI-Embed-access-token-issue-with-ABP If we are trying to add scopes unable to login to the application after changing AD configuration.

Note: tenant-based login

please help to resolve the issue.

Thank you.

Hi

can you remove

and add scopes like this

please try this i am able to get reports like this.

Hi Anjali, These changes are fine for get the access token for power BI.

Thank you so much! :)

• ABP Framework version: 7.3.2
• UI Type: MVC
• Database System: EF Core (SQL Server)
• Tiered (for MVC) or Auth Server Separated (for Angular): no
• Exception message and full stack trace:
• Steps to reproduce the issue:

Using Azure AD for Login to the ABP application and trying to call PowerBI API for embed the reports.

Azure Code

Token is generated by following post. https://support.abp.io/QA/Questions/5253/Token--Authentication

But token generated while login to the application not accepted by the PowerBI API

Azure AD API Permissions

Token is getting by the following code

public override async Task SignInAsync(IdentityUser user, AuthenticationProperties authenticationProperties, string authenticationMethod = null) { if (authenticationMethod == "AzureOpenId") // is github external login { var githubAuthenticateResult = await Context.AuthenticateAsync(IdentityConstants.ExternalScheme); if (githubAuthenticateResult.Succeeded) { if (githubAuthenticateResult.Properties != null) { authenticationProperties.StoreTokens(githubAuthenticateResult.Properties.GetTokens()); } } }

        await base.SignInAsync(user, authenticationProperties, authenticationMethod);
    }
}

access_token = await HttpContext.GetTokenAsync(OpenIdConnectParameterNames.AccessToken);

I am trying to fetch the data from the powerBI API by passing the token, but token is not accepted by the power BI API

$.ajax({ type: "GET", url: "https://api.powerbi.com/v1.0/myorg/groups", headers: { "Authorization": Bearer ${access_token} }, contentType: "application/json; charset=utf-8", success: function(data) { ....

We are trying the get the data from PowerBI API by using the AzureAD access token generated while login to the abp application.

But token not working for PowerBI API

Note: User has permission to access PowerBI Dashboards, Reporst, Datasets.

Please help to resolve the issue.

Thank you ABP.

Hi, I have tried with demo app as well but same exception occurred.