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.
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.
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 |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |