Forum Discussion
RLS
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
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
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
2 Replies
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
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