RLS in Manage aggregation giving error.

Hi Anonymous ,

Does your RLS meet the following condition?

"To work correctly for aggregations, RLS expressions should filter both the aggregation table and the detail table."

Best regards,
Lionel Chen

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

v-lionel-msft 

mwegener 

Found the problem.

By misktake I've added report level filter from aggregated report after removing that filter RLS worrking fine.

All filter should come from dimesion tables or DQ fact(only if required). 

"To work correctly for aggregations, RLS expressions should filter both the aggregation table and the detail table."

Thank you Both for the support .