RLS filter on multiple tables is giving blank

[Anonymous]

I'm trying to apply RLS on a pbix having multiple tables on a categorical datapoint.

Was able to apply filter on a single table but when I apply on another table, the result is blank in all the charts.

The tables are mapped with a 1 to many relation.

Any idea why?

And whats the workaround for it?

[TeigeGao · Accepted solution]

HI @Anonymous ,

Do you mean that it works when you filter it on the one end but not work on the many end (one to many relationship)? Please check if you have enabled the "Apply Security filters in both directions".

Best Regards,

Teige