Forum Discussion
Row Level Security - hide table for all but named users
Hi
I have a model and I want to hide one table from all users except for a few named users. Is there a way that I can create a role such that named users can see the table, but everyone else (added to the workspace) is prevented from seeing the table. This way if someone is added to the workspace by default they won't see the data from the table.
Cheers
Ed
Hi ed_mcdill ,
Power bi allow you to create a office security group to dispatch roles, then you only need to add members to that group to enable RLS roles.(notice: power bi groups not support)
Row-level security (RLS) with Power BI
Regards,
Xiaoxin Sheng
6 Replies
Hi ed_mcdill ,
AFAIK, RLS works on data model table records. It is impossible to use RLS to hide table, but you can use RLS to filter all records and keep a blank table there.
Regards,
Xiaoxin Sheng
Hi Xiaoxin
Thanks for the response. I've set up a role and am able to hide all rows of the table to members of that role. However my I don't wan't to have to add new members to this role. I would like an exception based role. Therefore if you aren't a member of a role then you will not see the rows of the table, but if you are members of a role then you will see them. It seems the opposite way in which it usually works.
Not sure if I was very clear :smileyhappy:
Hi ed_mcdill ,
Power bi allow you to create a office security group to dispatch roles, then you only need to add members to that group to enable RLS roles.(notice: power bi groups not support)
Row-level security (RLS) with Power BI
Regards,
Xiaoxin Sheng
