Forum Discussion
Solved
How to go about in implementing RLS
Need guidance in implementing row level security on the below Employees table: Employee Local Department Department Manager ID Johnny Depp Data Analytics Finance Kris Moll Brad Pit...
Hi,
If you have only two layers it can be handled by following:
1) Join emails of Employee as "Employee Email" and Manager's as "Manager Email". In the Desktop follow this:
https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security
2) Here you define 2 roles "Employee" and "Manager"
3) For employee role you set "Employee Email" == userprincipalname()
4) For manager role you set "Manager Email" == userprincipalname()
5) Follow RLS configuration in the Power BI Service after publishing
