In power bi report, you can sepecify roles associated with the report
under the Modeling tab, go to Manage roles
create different roles for the selected tables
each table will need table filter for the role, e.g. [Region]='East'
what it does it automatically filter the table based on the user's role
the filter must be specified in DAX expression
After the report is deployed to powerbi service
The semantic model file has the 'security' setting through the 3 dots "..."
In the security setting, all the specified roles will be brought up as 'Row-Level Security'
Each of the roles can be further added with members
Simply type in the email to add users to each role
Note the Row-Level security only applies to users with viewers permission
The report permission (viewer, contributer, etc.) is managed through the 3 dots "..." and Manage Permissions
Once roles are specified for a report, viewers not assigned to any role will be not be able to view any data.
Specifying filter on one table in the report can cascade to other tables join to the filtered table.
If the relationship between tables is too complex (look up, string concat, etc) instead of direct join, the filtering
can not be cascaded because power bi can not figure out.
In Row-level security setting, select a role and can Test as Role
This helps to test a new user's access to data.
A user can be assigned to multiple roles.