Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |