Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone
I'm Using RLS and Direct Query mode when the user logs in it's showing his/her own data but if the user has some person's who are reporting to them then those data also will display.
But by default, I need to display the Logged in user details alone after that from the Slicer filter(Employee id for example) the person can select and see the details of who all are reporting to him/her.
This is possible or not if it's possible please help me get it.
Thanks in advance
Hi Charu,
Based on your description, do you mean that for example:
staffs can see part of report contents while boss can see all the contents which staffs can see. right?
You can create another column and save boss's UPN then click Modeling->Manage Roles using 2 solutions below:
1.Create a role "Boss and Staff" using DAX: [Boss] = userprincipalname() || [Staff] = userprincipalname()
2.Create two roles "Boss" and "Staff", in "Boss" using DAX: [Boss] = userprincipalname(), in "Staff" using DAX: [Staff] = userprincipalname()
Regards,
Jimmy Tao
Hi @v-yuta-msft
whether the Role 1) Boss and Staff and 2) Boss,3)staff all three I should create in the same report or else I need to have 2 reports that are one report for Boss and staff and another report for boss, staff
Hi Charu,
All of the Roles are set in one dataset which is related to one report, so you should create these roles in one report.
Regards,
Jimmy Tao
HI @v-yuta-msft
I tried your method, say for an example boss id is abc@domain.com and staffs who are reporting to the boss are xyz@domain.com and pqr@domain.com
once I share the report with the boss ie)abc@domain.com for the Role Boss and Staff it will show him 3records but what I'm asking is when the boss logs in he have to see his record. then In the filter, I'm having their Id so it will show the boss id and the person who is reporting to boss also will be there to see their details boss has to click their ID and see the details.
your Roles doesn't give me what actually I need, please correct me if I'm wrong
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |