Hi All,
We are trying to implement row level security on Power BI RS. But getting stuck on trying to create a column to compare userprincipalname function to our organization hierarchy. I have created a measure. see below:
My table is Incidents and I have organization hierarchy columns created so that managers can view all their employees records and employees can only view their own records. So I have compare the user name to all levels. The below measure works but I am not able to drag the measure into a page filter on my report so that it filters all my visuals.
The only reason I am having to do this is because I do not see a way to setup users to a role on power BI Report server. I have this security working in Power BI service.
Please advise if there is a better way for me to apply security in Power BI report server.
Thanks!
userSecurityNew = CALCULATE(
COUNTROWS(INCIDENTS),
FILTER(SUMMARIZE(INCIDENTS,INCIDENTS[Assigned_Email_Lookup],INCIDENTS[Organization Hierarchy Level 5],
INCIDENTS[Organization Hierarchy Level 4],INCIDENTS[Organization Hierarchy Level 3],INCIDENTS[Organization Hierarchy Level 2]),
[Assigned_Email_Lookup]= userprincipalname()
|| [Organization Hierarchy Level 5]= userprincipalname()
|| [Organization Hierarchy Level 5]= userprincipalname()
|| [Organization Hierarchy Level 5]= userprincipalname()
|| [Organization Hierarchy Level 5]= userprincipalname()
)
)
