cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johlindr Frequent Visitor
Frequent Visitor

PowerBI embedd on Salesforce using app owns data scenario

Hello,

 

We have successfully used the power bi embedd on salesforce witht the user owns data scenario, but are now trying to get this to function with app owns data scenario for a different use case.

 

However we fail to get the appropriate apex code to do the authentciation part for this scenario, anyone has any usable code examples or suggestions how to get this to work ?  There doesnt seem to be any ready libs to use for this.

 

Any help would be appreciated

4 REPLIES 4
johlindr Frequent Visitor
Frequent Visitor

PowerBI Embedd on Salesforce App owns data scenario

Hello,

 

We are trying to get the App Owns Data scenario to work with PBI embedd on Salesforce but we fail to get the apex code to do the authentication properly. We have tried the user owns data scenario successfully, but we need the other scenario for another use case.

 

Has anyone got this to work with salesforce successfully, also if you can it would be really helpful with some example code as the apex does not seem to have any libraries available for the AAD authentciation flow.

 

Any help would be appreciated

v-ljerr-msft Super Contributor
Super Contributor

Re: PowerBI embedd on Salesforce using app owns data scenario

Hi @johlindr,

 

Could you recheck the steps in this documentation to prepare your environment first, and then follow this documentation(including the sample code there) to embed the content into your own application(app owns data)? Smiley Happy

 

Regards

johlindr Frequent Visitor
Frequent Visitor

Re: PowerBI embedd on Salesforce using app owns data scenario

Thanks for your reply. As mentioned we have it working for the first scenario User owns data, and we have all the backend things on BI and AAD side in place. It is however the below part that is the core issue (copy paste the .net example), I have no issue running this example in a .net app however the problem is how to implement the AAD Client and do non-interactive authentication using username+password from APEX code. Or is there another option for authenticating the service user? 

 

using Microsoft.IdentityModel.Clients.ActiveDirectory; // Create a user password cradentials.

 

var credential = new UserPasswordCredential(Username, Password); // Authenticate using created credentials var authenticationContext = new AuthenticationContext(AuthorityUrl); var authenticationResult = await authenticationContext.AcquireTokenAsync(ResourceUrl, ClientId, credential);

if (authenticationResult == null) {

return View(new EmbedConfig() { ErrorMessage = "Authentication Failed." }); }

 

var tokenCredentials = new TokenCredentials(authenticationResult.AccessToken, "Bearer");

nuno1977 Frequent Visitor
Frequent Visitor

Re: PowerBI embedd on Salesforce using app owns data scenario

Hi Johlindr,

 

Did you manage successfully the scenario Access token for non-Power BI users  ( app owns data) ?

 

Many thanks for your answer.

Nuno.