Forum Discussion

ricus_zero's avatar
ricus_zero
New Member
7 years ago
Solved

App only authentication - oAuth2 token request

Hi everyone   I'm making use of app-only authentication (the app owns data method), I've already set up a new group and created a service principle, as well as enabled the "Allow service principle ...
Need Help
Jayendran's avatar
Jayendran
Solution Sage
7 years ago

Hi ricus_zero 

 

Even SPN can able to create new workspace (V2). If you refered the difference between pro and SPN . you can find that solution.

 

There are 2 types of workspaces

  1. Classical (v1)
  2. Upgraded (v2)

PRO have access to both workspace, but SPN should have only v2 workspace. So if you are trying to add your your SPN in V1 workspace it won't work/ show. 

 

You can add the SPN only in the V2 (Upgraded workspace) (from GUI)

 

Pls see the below screenshot I can able to search the app id in my V2 workspace

 

ricus_zero's avatar
ricus_zero
New Member
7 years ago

Hi Jayendran 

 

Sorry for all the questions, your help has been tremendous so far! 

 

Am I correct in saying that it's possible for a normal license to create new workspaces via the service principle? (API call)

 

I attempted to create a new workspace via the REST API, making a call to the groups endpoint which got a 403 initially, I tried my luck and added the required scope to the access token call, and magic happened, I could now create a new workspace via the api, and then I assigned this workspace to my PowerBI user so that they can view it as well.

 

I added some of the sample dashboards and reports to this new workspace that was created via the api

 

So moving on from that, I then attempted to get the dashboard with the get dashboard endpoint, and got that "API is not accessible for application" response again. 

 

I then had a look at the Embed Token documentation since it's relevant to the App owns data scenario which if I'm not mistaken is what we are dealing with here.

 

I attempted to get an embed token for said dashboard. I once again had to change the scopes defined when getting the oauth access token, but after that I was able to get a proper response which includes the token / tokenId / expirtation and @odata.context

 

 

Now a seemingly simple question of, how do I actually use this embed token in our web app to display the embedded dashboard?

 

Hope you can help with this

 

Thanks

 

  • Jayendran's avatar
    Jayendran
    Solution Sage
    7 years ago

    Hi ricus_zero 

     

    Am I correct in saying that it's possible for a normal license to create new workspaces via the service principle? (API call)

    Yes you are correct 

     

    You shouldn't use get dashboard API using SPN token Instead use get dashboard in group

     

    Now a seemingly simple question of, how do I actually use this embed token in our web app to display the embedded dashboard?

     

    You can use SDK's See App owns data in dotnet

     

    Basically you need to pass the embed token to PowerBI Javascript

     

    <script>
    // Read embed application token from Model
    var accessToken = "@Model.EmbedToken.Token";
    // Read embed URL from Model
    var embedUrl = "@Html.Raw(Model.EmbedUrl)";
    // Read dashboard Id from Model
    var embedDashboardId = "@Model.Id";
    // Get models. models contains enums that can be used.
    var models = window['powerbi-client'].models;
    // Embed configuration used to describe the what and how to embed.
    // This object is used when calling powerbi.embed.
    // This also includes settings and options such as filters.
    // You can find more information at https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details.
    var config = {
        type: 'dashboard',
        tokenType: models.TokenType.Embed,
        accessToken: accessToken,
        embedUrl: embedUrl,
        id: embedDashboardId
    };
    // Get a reference to the embedded dashboard HTML element
    var dashboardContainer = $('#dashboardContainer')[0];
    // Embed the dashboard and display it within the div container.
    var dashboard = powerbi.embed(dashboardContainer, config);
</script>

    BTW you can give Like/give kudo's to my replies if you find it useful, by this way it will help others.