Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Experts,
I have attached a screenhsot below where i need to apply RLS,where if a cx selects company code-01, he should see all countries from company code 1, like same wise for all company code i need to implement same.
Please could you help me out on this.
Thanks in advance,
Regards,
HK
@Heena_9980400 , Assume you have company dimension joined with your fact or fact has company code
Create a Table with the company Code, segment, and email, and that should have all the details. Join it with dimension and fact and create RLS on this new table
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
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
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |