Forum Discussion
RLS row level security - not showing online
Hi Everyone - I have created the following role in my sales table. [Salesperson (groups)] = "HSRs" In the online enviornment, if I choose "test role", it works perfectly and only shows th...
That's correct, it's just them being members that is causing RLS to be ignored.
jdbuchanan71
Super User
Super UserHello Anonymous
Are the users in question members of the workspace? If so, RLS doesn't restrict their data.
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
If this is the case, rather than makeing them members of the workspace you should just share the report with them.
Yes, they are. It is a premium workspace and they are members of it.
The data is imported from Excel, and lives in OneDrive.
- jdbuchanan71
Then RLS won't be applied.
Oh, Ok. So what is the best solution to sharing a report with a large group of people (35). But only showing certain teams their information?