Forum Discussion

Nick_Kalichava's avatar
Nick_Kalichava
Frequent Visitor
3 years ago
Solved

RLS on Private servers

Hello. My company is not using Microsoft Servers due to privacy issues, so we have our own servers to upload BI reports. We have a several reports where a regular employee can see only personal r...
RLS without publish
d_gosbell's avatar
d_gosbell
Super User
3 years ago

If your 'staff list' table has a relationship to the rest of your data model you can get rid of all those extra measures and just create a single role which has a filter like the following:

 

'Staff List'[Manager - mails]  = USERPRINCIPALNAME() || 'Staff List'[Regular_Employee- mails] = USERPRINCIPALNAME()

 

Then you can create simple measures like SUM( table[column]) and the above filter will be applied by the Role.