Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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