Forum Discussion
Randalnik
8 years agoFrequent Visitor
Manage Roles - set row security level help
Hello everyone, I`m looking for an advice about security in Power BI. I have read a lot about the DAX and Manage Roles but I`m still not able to set it corectly. I would like to ask, where I`...
- 8 years ago
You can create a dynamic RLS with the function USERNAME() or USERPRINCIPALNAME(), that function will return the power bi user email, so you will have to create a table with all users email like [email protected] Tom and to make a relationship between that table to your Manager dimension. thats way you will have to make only 1 RLS rule. you can read more about it here:
http://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi