Forum Discussion

Anonymous

Not applicable

6 years ago

Multi Criteria or Tables for RLS

Hi all, Thanks for colleague assistance, I can handle multi layer RLS (Region, then country). However, I get a new requirement and need to control access for Sales Person. (add a new criteria) ...

Data Protection

Need Help

v-joesh-msft

Solution Sage

6 years ago

Hi Anonymous ,

Try the following:
1. Create a new table Region / County / SP, which is equivalent to groupby Sales Table according to the Region, Country, Sales Person fields, and create the unique field "custom"

2. Fill the unique field in the table Region / County / SP into the row of the table User Right (Step 1 Match Region) "All" and create the unique field "custom"
3. Create the relationship between the table Region / County / SP and the table User Right (Step 1 Match Region) with the custom column
4. Re-managing roles

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EcC_CsNcblFBiapts2L0wgsBI0s3lohHv8vKkmyqXHXFPQ?e=79NVla

Best Regards,

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

Anonymous

Not applicable

6 years ago

Thanks. I may try for it.

I upload my model and all sensitive data has been masked and I hope it can give you better idea.

Actual, there is no relationship between region and sales person and they came from 2 different data sources, but i may create a table for all combination of region and sales person.

But how can I keep to use DIM-Customer as filter table (slicers in report) as it get more customer information that exclude in User control table?

As I cannot build active relationship between User Control table and DIM-Customers table, and user can see all RSO value in the slicer even though they cannot view the data

(Steven should able to see DACH, NL, PL only).