Forum Discussion
RLS row level security - not showing online
That's correct, it's just them being members that is causing RLS to be ignored.
Should I publish to an "App" instead?
Super UserYou can or you can just share the report with them. It's just that the users you want RLS to apply to cannot be members of the workspace.
So if I publish it to an App, will the RLS be applied?
Or perhaps I could move the report to a different location....one where these members are not a part of....for example my own workspace which is also premium, and then the RLS would apply?
- jdbuchanan71
No, publishing the app will not apply RLS because the users are members of the workspace.
Why not just remove them as users on the workspace? You should not have users who should have restricted access as members of the workspace. Members of the workspace have access to all the data sets and date in the workspace.
If you do need to move the report to another workspace you should not use your personal workspace, just have the PowerBI admin create another workspace and add it to the premium capacity.
First.....Thank you for your help!! It's already been super helpful as I'm going to be working all weekend on this report.
The workspace was automatically created via a Microsoft Team that was created. We have 5 sales teams that need to see the report...plus executives that want to see the total report. The 5 sales teams of course just need to see their areas...but the execs want to see the full report.
So, I could create a new premium workspace...or upload the report to another premium workspace that we have already that they are not members of...and then the RLS would work, correct?