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 Team,
I have created dynamic RLS on powerbi
In table i have 3 columns
Type Country sales
B2B India 10
B2C India 20
B2B Germany 10
B2C Germany 20
Dynamic RLS table I have created like this
Type Country User
B2B India A@xyz.com
B2C India b@xyz.com
B2B Germany c@xyz.com
B2C Germany d@xyz.com
Because of many to many i have created bridge table for Country
Country
India
Germany
I have created role saying Dynamic = userprincipalname()
when I test the role for a@xyz.com he can see only "India" data but he is seeing for both B2B and B2C
we don’t want him to see for B2C we need to show him only for B2B India.
Could you please help me who to achieve this.
Solved! Go to Solution.
@amitchandak - Thanks a lot Amit. You are really genius. When ever I need help, all my questions I got answers from you.
@Balhemkan , The above two should join in a combined key
new column in both tables
Key = [Type] & "-" & [Country]
@amitchandak - Thanks a lot Amit. You are really genius. When ever I need help, all my questions I got answers from you.
User | Count |
---|---|
84 | |
79 | |
63 | |
62 | |
51 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |