Forum Discussion

mp390988's avatar
mp390988
Post Partisan
1 year ago
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...
  • OktayPamuk80's avatar
    1 year ago

    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