Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.