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
powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago

Hi Anonymous KNP ajaybabuinturi 

i have created seperate admin role with no filter on any table and it is working fine

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi powerbiexpert22,

 

Since the admin role has no filters and shows all data, this confirms that your data and relationships are set up correctly.

However, if the team lead’s salesperson IDs in the security table don’t match any salesperson IDs in the orders table, the filtered result will be blank.

 

Regards,

Vinay Pabbu

  • powerbiexpert22's avatar
    powerbiexpert22
    Impactful Individual
    1 year ago

    Hi Anonymous ,

    i will assign admin role to team lead so that they will see all data

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi powerbiexpert22,

       

      Perfect - assigning the Admin role with no RLS filter.

      Please let me know if you have any further questions. We are here to help you.

       

      Regards,

      Vinay Pabbu

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi powerbiexpert22,

         

        As we haven't heard back from you, At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.

        Thank you for being part of the Microsoft Fabric Community.

         

        Regards,

        Vinay Pabbu