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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bapt69
Helper I
Helper I

RLS related to active directory

Hi everyone,

I wanna create RLS with the Active Directory.

I got an active link between the Group (from AD, with "etablissement_id" related) and my table "etablissement" (with pk etablissement_id). There is a related table between users and groups and each group equal 1 "etablissement" (like a BU as well).

On one sheet, all is good and the filters are good. On the other ones, none filtrering isactivated...I don't know why...

 

Relationships :

bapt69_0-1685705572819.png

 

The sheet which is working :

bapt69_1-1685705635847.png

 

The sheet which is not working ("etablissement_nom_court" is comin from AD and "Etablissement" is cmin the Table "d_etablissement") :

bapt69_3-1685705728473.png

 

 

Thank you all!!

1 ACCEPTED SOLUTION
bapt69
Helper I
Helper I

I used USERELATIONSHIP which is a bad idea.....

I use INTERSECT instead of. All is workin! (and created a relationship between d_etablissement and correspondance)

View solution in original post

2 REPLIES 2
bapt69
Helper I
Helper I

I used USERELATIONSHIP which is a bad idea.....

I use INTERSECT instead of. All is workin! (and created a relationship between d_etablissement and correspondance)

bapt69
Helper I
Helper I

little add 😉 

 

I made this RLS :

bapt69_0-1685705917133.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.