Forum Discussion
How to append tables that are being filtered by RLS
I've found a solution for that puzzle.
1 - I kept the data model 1 and 2 without any RLS2 - Put the RLS 1 and 2 together with the RLS 3, and then added a UNION statement within the RLS to have all the results together.
*The reason for keeping the structures 1 and 2 was because the DIM tables and FACT tables were using different primary keys in their relations. It worked perfectly!
Dynamically because the RLS is using the USERPRINCIPALNAME as one of the multiple conditions within it.
I'm sharing a mock up of the data modelling so you can visually understand what I'm trying to do.
I've found a solution for that puzzle.
1 - I kept the data model 1 and 2 without any RLS
2 - Put the RLS 1 and 2 together with the RLS 3, and then added a UNION statement within the RLS to have all the results together.
*The reason for keeping the structures 1 and 2 was because the DIM tables and FACT tables were using different primary keys in their relations. It worked perfectly!