Forum Discussion
Row Level Security - assigning roles by groups
Hydrometric It totally depends on your data and how you wish to implement the RLS. If you have a flat role where each individual will have access to his data only then you can have only one role that will be sufficient for all. If you wish to have people to be able to access data for multiple users then you will need to create multiple roles. It is always better to keep the RLS as simple as possible. Ideally your user table should filter the data for the user based on the role he/she is assigned.
I suggest you to go through various web articles to understand how RLS work and then align it with your org requirements. below are some links to get you started.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://radacad.com/row-level-security-configuration-in-power-bi-desktop
https://www.edureka.co/blog/row-level-security-in-power-bi/
https://blog.pragmaticworks.com/power-bi-and-data-security-row-level-security
Hydrometric It totally depends on your data and how you wish to implement the RLS. If you have a flat role where each individual will have access to his data only then you can have only one role that will be sufficient for all. If you wish to have people to be able to access data for multiple users then you will need to create multiple roles. It is always better to keep the RLS as simple as possible. Ideally your user table should filter the data for the user based on the role he/she is assigned.
I suggest you to go through various web articles to understand how RLS work and then align it with your org requirements. below are some links to get you started.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://radacad.com/row-level-security-configuration-in-power-bi-desktop
https://www.edureka.co/blog/row-level-security-in-power-bi/
https://blog.pragmaticworks.com/power-bi-and-data-security-row-level-security