Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
110 | |
109 | |
73 | |
71 |