Role Level Security

Question

Hello&nbsp;im new to RLS and having trouble.What am trying to achieve is, based on the userprincipalname return data for the groups he is in.unfortnantly i have to use username from fact_table to this bridge table below&nbsp;Ex:BRIDGE TABLEEmail&nbsp; (userprincipalname)&nbsp; &nbsp;|&nbsp; Group | Usernamepedro@gmail.com&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pedropedro@gmail.com&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pedroMario@gmail.com&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MarioJoana@gmail.com&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Joana&nbsp;What i want is that when pedro logs in, he sees data from his groups ( 1 and 2 ) while joana and mario only see data from group 1&nbsp;&nbsp;&nbsp;&nbsp;

v-janeyg-msft · Accepted Answer

Hi,&nbsp;Anonymous&nbsp;&nbsp;It’s my pleasure to answer for you.According to your description,I think you don't need to use 'UPN', you can create two roles filtering 'group=1'and 'group=2' in PBI desktop 'manage roles', then add members in PBI Service(role1:pedro,Mario,Joana email&nbsp; &nbsp; &nbsp;role2:pedro).Like this:Reference:Row-level security (RLS) with Power BI - Power BI | Microsoft DocsIf it doesn’t solve your problem, please feel free to ask me.&nbsp;Best RegardsJaney Guo&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Role Level Security

2 Replies

Related content

Role Level Security

Page level security

Lakehouse Column-Level-Security via OneLake Data Access Role

Changing Role for Row-Level Security

Object Level Security "Reverse" Role