Forum Discussion
Dynamic security rules with specific hierarchy
Hi menphis21
Thanks for reaching out to us.
please refer to these tutorials,
Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD
Using Dynamic Row-Level Security with Organizational Hierarchies (bluegranite.com)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi menphis21,
You can create the report without segregating them into pages and use Row Level Security to ensure that the right people are viewing it. Refer:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts
Thank you Shaurya ,
But the whole problem is that I have several user fields per line
so I can't join the Aging table with the users table
I also tried another option in DAX for depending on the Userprincipalname, it chooses the field it is based on :
if(CONTAINS(Aging,Aging[Email Chairman],USERPRINCIPALNAME()), Max(Aging[Email Chairman]),
if(CONTAINS(Aging,Aging[Head of Finance Email],USERPRINCIPALNAME()), Max(Aging[Head of Finance Email]),
if(CONTAINS(Aging,Aging[Managing Partner email],USERPRINCIPALNAME()), Max(Aging[Managing Partner email]),
if(CONTAINS(Aging,Aging[Head of email],USERPRINCIPALNAME()), Max(Aging[Head of email]),
if(CONTAINS(Aging,Aging[Email BI Partner],USERPRINCIPALNAME()), Max(Aging[Email BI Partner]),
if(CONTAINS(Aging,Aging[Email Manager],USERPRINCIPALNAME()), Max(Aging[Email Manager]),0))))))=USERPRINCIPALNAME()
Thank you for your help