Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would like to show only the data related to the viewer email, from what I read around it should be feasable in Power BI,
however I can't find a way.
I have already all the data in my data set, with 2 kind of users, employees and DMs, I would like to show different data (even in different pages)
EMP CODE | EMP AREA | EMP EMAIL | DM EMAIL |
123 | AAA | EMP1@EMAIL.COM | DM1@EMAIL.COM |
456 | BBB | EMP2@EMAIL.COM | DM1@EMAIL.COM |
EMP AREA connects this table to all my other data (1:many relationships)
Anyone could help?
Thanks in advance
Solved! Go to Solution.
Hi @df123445 ,
As @Greg_Deckler said, to verify that your configured rls is in effect, just select view as. The reference is below:
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @df123445 ,
As @Greg_Deckler said, to verify that your configured rls is in effect, just select view as. The reference is below:
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@df123445 Yes, this is done by creating an RLS rule on the table and using USERPRINCIPALNAME such as:
[EMAIL] = USERPRINCIPALNAME()
Many thanks!
I've done the following and seems to work
But is there any way to test this?
I've tried "View as" but whatever I select the data doesn't seem to be filtered
@df123445 So when viewing as, you need to select the role and then "Other user" and type in the email address of the other user who you want to impersonate.
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |