Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sidyahmet
Frequent Visitor

Row level security with multiple profil

sidyahmet_0-1701880164760.png

Personnel table

 

id_useruseremailstatusstore
1jonathan32jonathan32@bi-ready.comDirecteur des ventesToulouse
2maxgrantmaxgrant@bi-ready.comChef de storeCannes
3lberrylberry@bi-ready.comVendeurMetz
4arnoldsamanthaarnoldsamantha@bi-ready.comVendeurLe Havre
5ijohnsonijohnson@bi-ready.comVendeurNantes
6leahsmithleahsmith@bi-ready.comChef de storeSaint-Paul
7derrickchungderrickchung@bi-ready.comVendeurCréteil
8roberthollowayrobertholloway@bi-ready.comVendeurRoubaix


status colonne have three profile "Directeur des ventes","Chef de store"and "Vendeur".

I need to create a dynamic role in power bi desktop to filter data by email and status using Userprincipalname().
- User with status Directeur des ventes, can show all data any restriction with this user
- User witht status Chef de store can only see data associated with their store
- User with status Vendeur can only see row with only data.
I beguin doing this role  formula in dax role Email=Userprincipalname() 
How can I improve the formula to account for the cases mentioned above?


1 ACCEPTED SOLUTION
sidyahmet
Frequent Visitor

I finaly found the solution
thanks

View solution in original post

1 REPLY 1
sidyahmet
Frequent Visitor

I finaly found the solution
thanks

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors