Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 in the Manage role creation?
For example:
Employee_ID | Employee_Name | Reporting_TO_Name | Email_address
1 | John | Ajay Kumar | john@domain.com
2 | William | Ajay Kumar |william@domain.com
3 | Ajay | |ajay.srs@domain.com
If Ajay logs in then he can able to see all the records based on Reporting_TO_Name, here the Reporting_TO_Name Ajaykumar both belong to ajay.srs@domain.com
when ajay logs into power bi service in the profile tab on right corner his name display as Ajay Kumar and email id is ajay.srs@domain.com
I used the roles as
[Email_address] = USERPRINCIPALNAME() ||
[Reporting_TO_Name] & "@domain.com" = USERPRINCIPALNAME()
I want to compare the Reporting to name with the display name once user logins.
Please Help me to get the solution on this.
Thanks
Solved! Go to Solution.
@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,
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
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.
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
@Charu,
Create a new column in your table using DAX below.
is manager = IF(Table[Reporting_To_Name]="",1,0)
Create the role using DAX below.
If(MaxX( Filter( Table, Table[Email_address]=Username()) ,Table[is manager])=0, Table[Email_address]=Username(), 1=1 )
Reference:
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
Regards,
Lydia
I'm getting the following error message as
Function 'MAXX' is not allowed as part of the row level security expression on DirectQuery models
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |