RLS

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