Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have the Below Tables, and they are related by EmployeeName. I am trying to create a security for Row Level .
I using [lnemployee] as a filter in LoanDetails , but is it possible to use [MgrEmailAddress] as well from the EmployeeHierarchy table into the LoanDetails Filter.
Regards,
Solved! Go to Solution.
@Anonymous,
No, it is not possible to use [MgrEmailAddress] from the EmployeeHierarchy table into the LoanDetails Filter.
You don’t need to add any expression in LoanDetails table, just add “[MgrEmailAddress]= usename()” expression in EmployeeHierarchy table. As you have created the relationship between the two tables, the LoanDetails table will be filtered to return correct rows with the “[MgrEmailAddress]= usename()” expression.
Regards,
Lydia
@Anonymous,
No, it is not possible to use [MgrEmailAddress] from the EmployeeHierarchy table into the LoanDetails Filter.
You don’t need to add any expression in LoanDetails table, just add “[MgrEmailAddress]= usename()” expression in EmployeeHierarchy table. As you have created the relationship between the two tables, the LoanDetails table will be filtered to return correct rows with the “[MgrEmailAddress]= usename()” expression.
Regards,
Lydia
Hi,
I use the email too, but since we have a "complex" employee hierarchy, I use different rls for each hierarchy, and to check the email with the user, i use this:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |