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.
Hello everyone,
this topic is about RLS, and unfortunately I'm not familiar with it yet.
I have a table "Order list" (a long list from Sharepoint) which is connected to PowerBI.
There is a column "E-mail", the e-mail address of the user who triggers the order is saved there.
The requirement is, that the logged in user should only see the rows of his own orders. By the measure
Solved! Go to Solution.
@Anonymous , based on what I got
Create a role and filter
'Order list'[Email] = userprincipalname()
refer if needed
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
@Anonymous , have you tested the role as view as the role and by passing email id?
I've just tested it, indeed, it works! Thank you soo much!
Best regards
@Anonymous , based on what I got
Create a role and filter
'Order list'[Email] = userprincipalname()
refer if needed
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
Thank you for your answer, I tried it but nothing changed.. I still can see the orders of my colleagues
@Anonymous , have you tested the role as view as the role and by passing email id?
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |