Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago

dynamic rls

i have below orders data . i want to create security table which should store salesperson details along with address to apply dynamic RLS in such a way so that each salesperson should see respective ...
Need Help
KNP's avatar
KNP
Super User
1 year ago

When you test as other user, you still have to tick SalesRole. 

See if that helps. 

 

  • powerbiexpert22's avatar
    powerbiexpert22
    Impactful Individual
    1 year ago

    Hi KNP ,

    I have tested as SalesRole however it is giving me blank table as shown below

  • powerbiexpert22's avatar
    powerbiexpert22
    Impactful Individual
    1 year ago

    Hi KNP ,

    i tired with both option (SalesRole and Other user) , it is giving me expected results however when i tried with team lead id ( [email protected]) it is giving blank table

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi powerbiexpert22,

       

      Can you please check USERPRINCIPALNAME() matches the email in the Security table exactly.

       

      Regards,

      Vinay Pabbu

      • powerbiexpert22's avatar
        powerbiexpert22
        Impactful Individual
        1 year ago

        Hi Anonymous ,

        yes