Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Add a default role for row level security

I want to be able to assign all users (including new ones) to a default role in RLS. Currently I have to assign each user to the role manually, and update the roles manually when users change. This limits the ability to use RLS with a larger user base.
Status: Needs Votes
Comments
me35
New Member
I just realised Other User allows you to check against a specific users email. Bugger.
eavanvalkenburg
Microsoft Employee
Any updates on this? I need this function very much for a group a couple of hundred people all over the world, changing everyday!
JHouck1
New Member
Totally agree - we need the ability to assign a "Default" role to all users. This would add incredible power to RLS so that you are only assigning a different role if needed, rather than for EVERY user.
SAM34
New Member
Would very much like to see this appear in the near future - with a growing amount of users accessing Power BI, the ability to assign a default role that restricts visible data would be incredibly useful.
andreas_krause
New Member
Agree - if we could have some role defined for those who are not assigned to a role this would be good. For the time being I'm using a corporate GMS group to add everyone.
jimbudde
New Member
I am in strong agreement with others on this feature. If someone grants access to a report (there are many at this point) but forgets to add them to a specific role/group, the current default behavior is to grant access to ALL data; a bit backwards logic if you ask me.
kriishnakanth
New Member
is the RLS available in new workspace yet?
george_tylee
New Member
To mimic a default role with no permissions, I am experimenting with importing two matching sets of data, one with the true (positive/negative) sign and one with the opposite. In the 'Manage Roles', the specific role has a DAX filter to only include the correct data. Thus with no role selected in the web service (the default) a zero sum is shown, but if a role is allocated the actual amount is.
Alexander_Knig1
New Member
One option could be to use Office 365 Groups to assign all users to the RLS in the service.
samuel_vrbovsky
New Member
Please add this feature. This would help immensely.