Forum Discussion
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 ...
Hi Anonymous KNP ajaybabuinturi
i have created seperate admin role with no filter on any table and it is working fine
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
Hi Anonymous ,
i will assign admin role to team lead so that they will see all data
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