cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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 Smiley Happy

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Hi Xiaoxin

 

Thanks for trying to help, unfortunately I don't think that I've accurately described my problem. So whilst what you say is very valid it isn't a solution to my question. I keep reading the documenation and the blogs. Cheers Ed

 

 

Hi Ed, 

 

Any chance you solved that? Really interested in the solution!

 

regards,

Louis

Unfortunately not, I didn't really pursue it further. Good luck!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors