Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

RLS based on User Table

Hello everyone.   I would like to add RLS to a PBI file by using one of the source tables as the user list. I have the following tables:  I would like to use the User table to restrict or pr...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    It's resolved! The issue was the DAX function: is not USERNAME(); is USERPRINCIPALNAME().

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Anonymous ,

 

Here is my example:

PS: For more details please refer to the attachments

 

Please try:

First duplicate the user table and then split column:

Output:

Then create relationship:

Then apply the RLS:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Jiambo,

     

    So, I tried adding some more data to the tables and replacing the usernames for real ones to test the solution, but unfortunately it didn't work... I don't know if I'm doing something wrong, but this is what I see:

    Now, I changed the RLS filter to the "User (2)" table, assuming that was the issue, but still no good result. 

    Any thoughts on this?