Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help user to find their support

I have two lists  ListEmails: Email/city/country ListSupport: Email/city/support1/support2   All people from List2 are in List1 -but not the other way. The foreseen behaviour is that the user ju...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 

     

    You can first create a relationship between List 1 email column and list 2 email column, then create an dynamic RLS group based on the username using the list with all username.

     

    List1[Email] = USERPRINCIPALNAME()

     

    Final step is publish to Service and assgin users to this RLS group on PBI Service after publish.


    Paul Zheng _ Community Support Team
    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
5 years ago

Anonymous 

 

You can first create a relationship between List 1 email column and list 2 email column, then create an dynamic RLS group based on the username using the list with all username.

 

List1[Email] = USERPRINCIPALNAME()

 

Final step is publish to Service and assgin users to this RLS group on PBI Service after publish.


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