username

[Milozebre]

Good evening dear community, 

I need your help. I would like to use the username as a filter. I will see the information related to the user. I would also like when the manager connects, he asks him if he wants to be user or manager. 

Username format : Domaine\firstname.lastname

You can find picture of tables in attachment. 

I try roles, I try video on youtube but doesnt works.

Thank you very much in advance. 

https://ufile.io/86ayu

https://ufile.io/2twbf

[chass · Accepted solution]

Please see: 

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

[v-yuta-msft · Accepted solution]

Hi Milozebre,

Modify your Role like below and check if it can meet your requirement.

 

Regards,

Jimmy Tao

[chass · Accepted solution]

Please see: 

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

[Milozebre]

Hello, 

Its working. 

My fault were : 

I create measure with username in desktop and it's working but when I publish, it doesn't. The usernam was different. In local its with domain\user and in web : mail address.

Second point : When i read the documentation, i read to fast and forget to read : 

if you have configured the app workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.

MEMBERS CAN ONLY VIEW ...

When I change that, its working fine. 

Thank you 

Dimitri