Forum Discussion
Row Level Security WITHOUT user Email, based on userid
Hi Anonymous ,
RLS is divided into dynamic and static, and dynamic requires the use of USERPRINCIPLENAME or USERNAME.
Using the username() or userprincipalname() DAX function
Depending on your requirements, you do not need to use the above two functions. You have static RLS here, which can be created after my example below.
Create two roles. One is the role of user ID123 and the other is the role of user ID456. Because my sample data is only 123 and 465, you create multiple characters based on your sample data.
The results of testing are as follows.
After you save your report in Power BI Report Server, you manage security and add or remove members on the server.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
RLS is divided into dynamic and static, and dynamic requires the use of USERPRINCIPLENAME or USERNAME.
Using the username() or userprincipalname() DAX function
Depending on your requirements, you do not need to use the above two functions. You have static RLS here, which can be created after my example below.
Create two roles. One is the role of user ID123 and the other is the role of user ID456. Because my sample data is only 123 and 465, you create multiple characters based on your sample data.
The results of testing are as follows.
After you save your report in Power BI Report Server, you manage security and add or remove members on the server.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.