topic Power Bi Embedded RLS with REST API in Developer

Power Bi Embedded RLS with REST API

dcruise — Fri, 11 Aug 2017 18:57:45 GMT

Hello all,

This is kind of urgent so any quick help would be greatly appreciated.

We have built out a Proof of Concept web-app that will embed Power BI Dashboards. When a user signs in, we want them to only be able to view the data that belongs to their organization. We are currently doing all of the token and authentication through the Power BI Rest api. We are able to embed our dashboards just fine.

In desktop, I create a user role that determines if Email=USERNAME(). In desktop this works great, when you are not the correct user, you see blank visualizations and when you are, you see the appropriate data. I publish this into my workspace. I test the RLS there, works just fine. I embed it into our webapp and unfortunately anyone can see all of the data. (RLS is NOT working once embedded).

Again, we are handling authentication thorugh REST API. I believe this is the shortfall. I think we need to use the javascript library to generate the report token while passing in the username/role. Is this a correct assumption?

Here is what we are doing with the REST API. But again, when we go to the dashboard, no RLS seems to be working. Any advice?

def get_power_bi_embed_token(email, adal_session, dashboard_id):
    GENERATE_EMBED_TOKEN_URL= "https://api.powerbi.com/v1.0/myorg/groups/%s/dashboards/%s/GenerateToken" % (settings.POWER_BI_GROUP_ID, dashboard_id)

    response = adal_session.post(GENERATE_EMBED_TOKEN_URL, json={
        "accessLevel":"View",
        "username":email,
        "roles":"User",
    })
    return response.json()['token']

Re: Power Bi Embedded RLS with REST API

Eric_Zhang — Wed, 16 Aug 2017 10:21:11 GMT

@dcruise

Based on my test, the RLS is avalaible for the embedded reports and it is not available for embedded dashboards(confirmation from product team). See GenerateToken. While trying to call the embed token API for a dashboard with the POST body JSON as below, it response with error message "Creating embed token with effective identity for reasources of type Dashboard is not supported". The embeded view token generated in your case can view all data. So to apply RLS, you may have to embed a report at this moment.

{   
    "accessLevel": "View",
    "identities": [     
        {      
            "username": "EffectiveUsername",
            "roles": [ "Role1", "Role2" ],
            "datasets": [ "fe0a1aeb-f6a4-4b27-a2d3-b5df3bb28bdc" ]
        }   
    ] 
}

Re: Power Bi Embedded RLS with REST API

dcruise — Wed, 23 Aug 2017 00:03:36 GMT

Thank you, Eric!

Ironically enough, they released the documentation for this functionality literally the afternoon I posed the question! Its working great! Hoping the functionality trickles down to dashboards soon!

Thanks again!

Dylan

Re: Power Bi Embedded RLS with REST API

Anonymous — Thu, 21 Sep 2017 19:10:17 GMT

@Eric_Zhang can you please check with the product team, if I can pass in EffectiveIdentities to reports that use SSAS Live Connections and have roles there?

Re: Power Bi Embedded RLS with REST API

Eric_Zhang — Fri, 22 Sep 2017 01:18:56 GMT

@Anonymous

See Working with Analysis Services live connections

Re: Power Bi Embedded RLS with REST API

Anonymous — Fri, 22 Sep 2017 21:18:58 GMT

I looked at it last week but I am not able to make it work on my application.

I have done everything according to this link