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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.