Forum Discussion

Nazdac911's avatar
Nazdac911
Helper II
3 years ago

Applying RLS on 2 Dims tables that affecting same Facts tables

Dear All 
I have the follwoing data model : 

I want to apply RLS to filter Dim_location_purchase and Sales tables depnding on the access list located in the User_access table. 
I want to use Userprinciplename() function to detect user email. 
It should be straight forward but what ever I tried  , filter is always being cancelled when applying on both Dim tables !! 
Any solutions ? 
Thanks in advance 
Regards 

No RepliesBe the first to reply