rls - users not assigned to roles

hi, willharris24

     RLS is used to restrict access to row data.

You can use it in combination with USERNAME or USERPRINCIPALNAME.

Reference:https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/

for example:

If I don't want "v-lili6" this to a row of data or an entire table.

then set rls like this:

then if "v-lili6" open the report

before use RLS

After use RLS

If you want to add a new account that do not have access to the row data, you just modified formula in the Manage Role

Now, "v-lili6"and "v-frank" all do not access to data in table4

Note:

If you have configured the app workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.

Secure individual rows of data but users can always see either the details or the summarized data

Reference:https://docs.microsoft.com/en-us/power-bi/desktop-rls

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

Best Regards,

Lin