Forum Discussion
Dynamic RLS not working for two columns
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 [email protected]
B2C India [email protected]
B2B Germany [email protected]
B2C Germany [email protected]
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 [email protected] 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.
amitchandak - Thanks a lot Amit. You are really genius. When ever I need help, all my questions I got answers from you.
3 Replies
- BalhemkanHelper III
- amitchandakSuper User
Balhemkan , The above two should join in a combined key
new column in both tables
Key = [Type] & "-" & [Country]
- BalhemkanHelper III
amitchandak - Thanks a lot Amit. You are really genius. When ever I need help, all my questions I got answers from you.