cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SaudMeethal Regular Visitor
Regular Visitor

RLS filter on multiple tables is giving blank

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?

1 ACCEPTED SOLUTION

Accepted Solutions
TeigeGao New Contributor
New Contributor

Re: RLS filter on multiple tables is giving blank

HI @SaudMeethal ,

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

Snipaste_2019-04-11_14-17-15.png

Best Regards,

Teige

1 REPLY 1
TeigeGao New Contributor
New Contributor

Re: RLS filter on multiple tables is giving blank

HI @SaudMeethal ,

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

Snipaste_2019-04-11_14-17-15.png

Best Regards,

Teige