Need Help on RLS on Fact table.

[kanth123]

Hi..

How to implement RLS based on mutliple fields.

Need to filter based on Rep_flag in RSL table, Data_Flag field in Fact table and Key.

Rep_flag =type1 / data_flag =1 

Rep_flag = type2/ data_flag =0

Rep_flag = type3/ data_flag = 0 and 1 

while below approach works ?

create three user roles : (Type1,Type2,Type3)

Add filter on fact table 

data_flag =1  for role type 1 

data_flag =0 for role  type 2 

Thanks

[Anonymous · Accepted solution]

Hi @kanth123 ,

I created a sample pbix file(see attachment), please check whether that is what you want.

In addition, you can refer the following documentations to implement it.

Row-level security (RLS) guidance in Power BI Desktop

Row Level Security Configuration in Power BI Desktop

RLS with TWO Fact tables in Power BI

Best Regards