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!
Why dynamically? Why can't this be a calculated table? What's the purpose of that table ?
"live connected Microsoft List" - please elaborate. I am not aware of that option.
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 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!