Forum Discussion

Charu's avatar
Charu
Post Patron
8 years ago
Solved

Dynamic RLS role creation based on Login name

  Hi Everyone, Based on the user logged in for them their own record and the person who is reporting to the logged in user those details also should display  How to compare the logged in username ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Charu,

    In your scenario, create two roles, one using the DAX below. In Power BI Service, add Ajay as member of this role.

    1=1


    Another using DAX below.

    [Email_address] = USERPRINCIPALNAME()



    Regards,
    Lydia

Charu's avatar
Charu
Post Patron
8 years ago

Hi Anonymous

I'm already doing the way you suggested, I thought there is no other option so I tried the same like you shared .

Thank you so much for your support. :womanhappy:

Ara93's avatar
Ara93
New Member
7 years ago

Hi how did you solve the problem even i am facing the same issue kindly share the resolution. i am using direct query.

 

thanks,

Aravindan M