RLS for all tables

[merol007]

I had a question about the working of RLS about filtering through the whole model based on the userprincipalname. We have the following data model.

The RLS is applicable on table ‘aut_gebruiker’ (option ‘Manage Roles’). See below.

Short explanation of the data model. We have the following tables:

• _Gebruiker Licentie (fact table)
• Gebruiker (dimension table)
• Organisatie (dimension table)
• aut_organisatie (bridge table)
• aut_gebruiker (this table is filtered based on the userprincipalname)

What I want is based on the filter ‘aut_gebruiker’ (through the role) that all tables will be filtered for the authorized person. I set in each relationship the ‘both direction’ option with the idea to filter the whole model based on the userprincipalname. The challenge what I now have is that every table is filtered except the ‘Gebruiker’ table. I put all columns of the ‘Gebruiker’ in a table visual and see all the data (also the not authorized data). When I for example combine the ‘Gebruiker’ data with columns of table ‘_Gebruiker Licentie’ or ‘Organisatie’ then I see only the authorized data.

Is there a logical explanation why the table ‘Gebruiker’ didn’t automatically filtered? I read some articles/blogs about RLS but didn’t found a solution to filter the data for all tables. I hope you can help me with suggestions and hopefully I get more clear how the RLS exactly works within the Power BI model.

[v-luwang-msft]

Hi @merol007 ,

Check the key point to note：

Now in order for this to work, you will need to apply the tick next to “Apply security filter in both directions”

NOTE: If this is not enabled or ticked the Dynamic RLS will not work correctly.

So once done it will now look like the following below (“Apply security filter in both directions” must be clicked):

• 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien

[merol007]

Hi Lucien,

Thanks voor your response. I did check the box 'Apply security filter in both directions' (see data model screenshot) but the filtering didn't work for the whole model. 

Regards,

Murat.