Row-Level security: Making certain rows visible

[Anonymous]

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

USER = USERPRINCIPALNAME()

the e-mail of the logged in user appears, but how can I make only the data of the orders visible which he triggered?

I have created a separate table which contains all the users and their e-mail addresses
and as I explained above, in the main table there is already a column with the e-mail.
Which steps are missing?

I would be so thankful if you could explain it step by step!

Best regards

[amitchandak · Accepted 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]

I've just tested it, indeed, it works! Thank you soo much!

Best regards

[amitchandak · Accepted 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]

Thank you for your answer, I tried it but nothing changed.. I still can see the orders of my colleagues

[amitchandak · Accepted solution]

@Anonymous , have you tested the role as view as the role and by passing email id?