Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
We have a requirement where we have to dynamically restrict the data based on user's unit and country.
Please find below tables which we have
User Details Table
ID | COUNTRY | UNIT | REGION | User_ID |
1 | Algeria | ABC | NA | EMP1@123.com |
2 | Argentina | ABC | NA | EMP1@123.com |
3 | Australia | ABC | NA | EMP1@123.com |
4 | Denmark | XYZ | APAC | EMP2@123.com |
5 | Hungary | XYZ | APAC | EMP2@123.com |
6 | South Korea | XYZ | NA | EMP2@123.com |
Country Table
COUNTRY |
Algeria |
Argentina |
Australia |
Denmark |
Hungary |
South Korea |
Unit Table
UNIT |
ABC |
XYZ |
Main Table
UNIT | COUNTRY | REGION | COL1 | COL2 | COL3 | COL4 | COL5 |
ABC | Algeria | NA | |||||
ABC | Argentina | NA | |||||
ABC | Australia | NA | |||||
XYZ | Denmark | APAC | |||||
XYZ | Hungary | APAC | |||||
XYZ | South Korea | NA |
With the help of Dynamic RLS we have to restrict the Main table by making use of USERPRINCIPALNAME and also we have to restrict user's country and unit as well in the report.
Thanks in advance.
Hello @v-yinliw-msft ,
When EMP1 access the report then he should be able to see the data from the country and the unit in which he has access.
In above countries we can have data of Unit XYZ but EMP1 should be able to see the data of Unit ABC only from the Algeria, Argentina, Australia countries.
Similarly when EMP2 access the report then he should be able to see the data from the country and the unit in which he has access.
In above countries we can have data of Unit ABC but EMP2 should be able to see the data of Unit XYZ only from the Denmark,Hungary,South Korea countries.
I hope now you will undertand the outcome of this requirement
Thanks.
Hi @Optimusprime_25 ,
Could you please show me what your desired result looks like?
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-yinliw-msft
EMP1 should be able to see the data in which country and unit he has access
Similarly EMP2 should be able to see the data in which country and unit he has access.
All countries contains both ABC and XYZ unit data, but access should be restricted on country and unit as well.
Thanks
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |