Dynamic RLS with multiple tables

[Anonymous]

Hi, 

I have the following problem, I need to apply a dynamic RLS to a table.
Said RLS comes from 3 different tables that filter the same table:

The 3 tables painted in yellow I need to apply RLS to the Dim_CostCenter table. Each of these tables contains the emails of the users.
The problem is that when applying the RLS of Cost Center it does not take into account the RLS of the other tables.

Example:
User A has to see Cost Center 1 (table RLS Cost Center) and also has to see group A of Group Fuction (this contains cost center 2 and 3 -> table RLS Group Function) which the final result for user A is that he has to see Cost Center 1,2 and 3.

Any suggestion?

Thanks!

Regards!

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

Since there is only one relationship diagram, I can't give more details RLS code suggestions.

You can try:

Secondly, it is recommended that you create a separate user table as a slave table, and then connect to other related tables, so that you only need to use the user table and set the conditions of the user table, RLS can be performed.

Reference:

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey