Role-Based Default Filter Context

Hi,

I have a table in which different roles and the members corresponding to each role are mentioned.
Example: TableName : Roles

I have few visualizations for data like sales details, revenue etc. all these tables have a foreign key from the role table.
Now i need to take each role from the table 'Roles' and show hide visualizations based on roles. for ex: manager should see the revenue details where as the sales person should not. Also, enforce row level security to all the users in this table like each sales person should see the sales details related to them only.

Is there any way where the users can be automatically pulled from this table rather than explicitly mentioning in the Security ta of PBI Server.

How can i enforce these conditions in PBI ? Please advice.



Thanks in Advance!

Aparna Chandrasekar