Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have three employee categories where in the data I have 3 different countries XYZ. Where A category can see X,Y,Z data. B Category should see only Z data and should not see Y and X data. C Category can see only Y data.
Can anyone help me with this.
Thanks,
Kamal
Solved! Go to Solution.
@kamalbandam , refer for RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
A table like the one below is what you're going to need:
Employee Email | Category | Country |
Person1@email.com | A | X |
Person1@email.com | A | Y |
Person1@email.com | A | Z |
Person2@email.com | A | X |
Person2@email.com | A | Y |
Person2@email.com | A | Z |
Person2@email.com | B | Z |
Person2@email.com | B | Z |
Person3@email.com | C | Y |
Person3@email.com | C | Y |
You will need to combine it with a mapping table as the relationship will connect to the country, which isn't distinct. Keep in mind that RLS filtering needs to be turned on specifically for double sided crossfiltered relations. You will find this in the relationship settings for each individual relation.
/ J
@kamalbandam , refer for RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |