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 SELECTCOLU...
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