Dynamic security

[Kavya123]

Hi Everyone,

I want to implement security to my reports.  If I login as  admin I should be able to see all orgs and participants can see  only assigned Orgs. Please help me to achieve this.

FAct:

Org Id, NAme, Sales Amount

100, AA,1000

101,BB,2000

102,cc,3000

103,DD,5000

OrgId , Email, Role , UserID 

100, aa.com, Admin,  1 

101,aa.com,Admin,    1

102,aa.com,Admin,    1     

103,dd.com,User,   1000

103,ee.com,User,   1001

103,aa.com,Admin,  1

[v-deddai1-msft · Accepted solution]

Hi @Kavya123 ,

You can create a dynamic rls in your model:

[OrgId] IN SELECTCOLUMNS(FILTER(Role,Role[Email] = USERPRINCIPALNAME()),"OrgId",[OrgId] )

For more details , please refer to https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi and pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EeQKnejtvghMgNN30C...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[veenashenolikar]

Hi @Kavya123 

Please refer the below link

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#:~:text=Row%2Dlevel%20security%20(....

If I helped answer your question please mark this as a solution

Regards,

Veena Shenolikar