Forum Discussion

PallaviKGVG's avatar
PallaviKGVG
Helper I
8 years ago

Row level security with multiple roles

Hi,   I have a report built and pushed on to power bi service. When i am embeding the report using Azure AD, i want to get a report filtered with the clientid and locationid which can be dynamic va...
Need Help
Tips and Tricks
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Pallavi,

 

It seems your embedded mode is "App Owns Data". Please refer to developer/embedded-row-level-security.

1. I would suggest you create two roles based on locationid and clientid. One role is also good if the two fields can be combined.

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

2. If not for the sake of security, I would suggest you use slicers to make the two fields dynamic. 

 

Best Regards,

Dale