...
You cannot assign users to a role within Power BI Desktop. This is done within the Power BI service. You can enable dynamic security within Power BI Desktop by making use of the username() or userprincipalname() DAX functions and having the proper relationships configured.
Power BI RLS Process
How To start with the Power BI RLS Process we must mention as previously explaned the Role Managing. To learn how to use the technique:
- Adding a new security role
...
- Select the Modeling tab.
- Select Manage Roles.
- Power BI RLS Process flow
...
Once the report is published, in PowerBI service, the username role created can be assigned to individual users or AD groups. So who ever signs-in to the report will see only the rows which has their netid.[1]
Findings:
- Workplace
If you are an Admin in the workspace you will always be able to see all data when you open a report no matter what is your security role assigned for a particular report.
...
Basically you cannot have one member in more than one Department row-level security role. The way the method is constructed it not allows one person to participate in more than one department. Same report shows data from the MULTIPLE departments an example non-VIP user is approved to access requirement not met.
A work around it can be creating Department row-level security roles that can have more than one department. So we can add multiple users to this role.
See below images with the role containing the Pediatrics department with Pathology:
...