Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I Have data like below : and am want to RLS to filter data as per the user access. Now the requirement is only for emplyee id '1234' I need to get complete details in access like he could able to see all the values in access column using RLS. Plz suggest
Useremail | employee_id | Department1 | Department2 | access |
kuamr@gmail.com | 1234 | abc | def | us |
xyz@gmail.com | 5678 | xyz | ghi | europe |
Thanks
kumar
Hi @Santosh19 ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.
Best Regards,
Eyelyn Qin
Hi @Santosh19 ,
If you want someone to see all the values when the dataset has been applied RLS, you could assign him editpermission.
You can make this change by logging in to app.powerbi.com (as a group admin), and using the left nav to choose the App Workspace (group) and then Edit Workspace.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Santosh19 - See https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/m-p/...
Basically, you need to create a rule where [Useremail] = USERPRINCIPALNAME()
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |