Restricting data

Hi emma313823 ,

For your case, you need to set roles for thousands of users, so we need dynamic RLS.

USERNAME() returns the domain name and user name of the current connection with the format of domain-name\user-name.

It is worth noting that If a user has access to a particular row of data, they can see all the columns of data for that row. So we cannot use RLS to limit the columns or measures accessible by my users.

Here are RLS related blog posts.

https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

Best regards,

Eyelyn Qin