Forum Discussion

ACCR's avatar
ACCR
Frequent Visitor
4 years ago
Solved

RLS Distribution List not displaying info

Hi! I've created a RLS in PowerBI using the DAX userprincipalname(). It works fine for the individual email adresses (makes me think that the tables and connections are ok) but when using distribut...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  , ACCR 

    System cannot identify user name . According to the offical document you can see that when you use username() or userprincipalname() , usually returns a user in the format of DOMAIN\User or a user in the format of [email protected]. When you enter the user's name, it can only determine that this is a text column, but not a user name column.

    Best Regards,
    Community Support Team _ Ailsa Tao
    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
4 years ago

Hi , ACCR 

Can you describr your operation in detail ? From the DAX you provided , there is no problem . Did you test RLS in Desktop ? Can RLS work ? Did you create relationship between User table and data table ? You can refer to the offical document to check your configuration . 

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls 

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ACCR's avatar
    ACCR
    Frequent Visitor
    4 years ago

    Hi! Thank you so much for the answer! 

    I am sorry I didn't give musch details.

     

    Did you test RLS in Desktop ? - Yes

    Did you create relationship between User table and data table ? Yes, the mapping is done correctly!

    The only thing that I am seeing is that the system do not recognize the user using Distribution Lists. Only if I write the users email individually, the RLS works.