RLS

[DanOnofre]

Hello,

I have more than 400 professionals who need to access power Bi, and each one has their own access, that is, I need to create more than 400 RLS

Note: I have several data from these users in a spreadsheet

There is a method to create and assign more than 400 RLS in a practical way or to make an RLS that captures the user's email by Office 365

[amitchandak · Accepted solution]

@DanOnofre , You can implement it using email id, value(In a table) in Power bI desktop and you can create an email-enabled list with all 400 employees and in power bi service assign the list to the role

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

[Anonymous · Accepted solution]

Hi @DanOnofre ,

You could check this document about using userprincipalname() to implement dynamic row-level security.

https://powerbidocs.com/2021/01/18/dax-userprincipalname-use-in-rls/ 

In short, you will need a table contains users and their email. This table will be able to filter the fact table by username. Then you will only need to create one role to implement dynamic row-level security by using userprincipalname().

Best Regards,

Jay

[amitchandak · Accepted solution]

@DanOnofre , You can implement it using email id, value(In a table) in Power bI desktop and you can create an email-enabled list with all 400 employees and in power bi service assign the list to the role

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk