RLS on Dim table and not Fact?

[ovonel]

Hi,

I have a model with around 20 tables, (18 of them Dim and 2 facts...)

I want apply dynamic RLS.

I wanted to apply the filter on a DimCostumer, like this:

=[SK_Cust] IN
SELECTCOLUMNS(
FILTER(
'Responsible'
,'Responsible'[NTUserName] = USERNAME()
)
,"Cust"
,'Responsible'[DW_Cust]
)

and then it be propagated to the rest of the tables (both fact tables...) is this doable/best practice? Or do I have to set RLS on each Fact. (I have SK_Cust on both fact tables...)

[v-yiruan-msft]

Hi @ovonel ,

How does your data model look like? Whether the relationship be created among the dimension tables and fact tables base on specific field(for example:SK_Cust field)? The following links are the ones for creating dynamic RLS examples, hope they can help you.

What Do You Need to Implement Dynamic Row-Level Security in Power BI?

Configuring “all” access with dynamic row-level security

DAX Code for Dynamic RLS

Best Regards

[amitchandak]

@ovonel , Doing on dimension is a better way. As using one dimension you can control more than one fact