Forum Discussion
RLS on Dim table and not Fact?
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...)
2 Replies
- amitchandak
Super User
Anonymous , Doing on dimension is a better way. As using one dimension you can control more than one fact
Hi Anonymous ,
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
Best Regards
