Forum Discussion

Balhemkan's avatar
Balhemkan
Helper III
4 years ago
Solved

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.

 

  • Balhemkan's avatar
    Balhemkan
    4 years ago

    amitchandak - Thanks a lot Amit. You are really genius. When ever I need help, all my questions I got answers from you. 

3 Replies