Forum Discussion
Why applying RLS causes problem to my model?
Hi Power BI Community, I have the following model on my Power BI: As you can see, there is a circular relationship between the 3 tables "learners_by_month", "paths" and "courses". I know t...
But there is a bi-directional relationship between learners_by_month and paths, as well as between learners_by_month and courses, so RLS is applied to those tables as well, right?
And yes, I know that it is preferable to have a star schema but I can't in my example, I need a filter on one of the 3 tables to be effective on the two others.
But there is a bi-directional relationship between learners_by_month and paths, as well as between learners_by_month and courses, so RLS is applied to those tables as well, right? not by default. You need to explicity request the security context to be passed bidirectional as well.