Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple Slicer with Row Level Security(userprinicipalName())

Hi Team, Good day, I have Two tables Country table below Country State population INDIA Maharastra 10000 INDIA AP 20000 UK ABC 40000 US CD 50000   Employee table ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi Anonymous ,

     

    Create relationships for columns Country\State\EmpName.

     

     

    Then create role:

     

    [State] = CALCULATE(values('RLS Table'[State]),USERELATIONSHIP('Country table'[State],'RLS Table'[State]))
    [Email] = USERPRINCIPALNAME()

     

    View as cheched with [email protected].

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Create relationships for columns Country\State\EmpName.

 

 

Then create role:

 

[State] = CALCULATE(values('RLS Table'[State]),USERELATIONSHIP('Country table'[State],'RLS Table'[State]))
[Email] = USERPRINCIPALNAME()

 

View as cheched with [email protected].

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-kkf-msft,

     

    Thanks for the solution, I have same data structure, but more columns to use for RLS, like I have Region, Sub Region, Country, RVP, Site and LOB.
    I'm exploring how to implement RLS using above 6 columns, all these columns are coming from one fact table, and I have a RLS Table. Could you please suggest me how to implement RLS using 6 columns.

     

    Thanks
    Pavan.