cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

5 REPLIES 5
Highlighted
New Member

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

Highlighted
Microsoft
Microsoft

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

Highlighted
New Member

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");

Highlighted
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.

 

Highlighted
Frequent Visitor

Re: PowerBI embedd on Salesforce using app owns data scenario

HI @johlindr 

Do you managed to have your PBI embedded into Salesforce page in app owns data scenario?

If yes, could you please share your steps?

Thanks,

Terence

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors