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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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