RLS not working with group based on a join

[asbada]

Hello,

Suddenly a RLS group stopped to work and members of this group visualize no data (without any error message) on report.

The rule in place is  based on a left join on a master table A and a table B wich list some information. The idea was to profide specific access to those users based on a join.

It was working like a charm but since 2 weeks it stopped.

No clue on what is missing. Could you please help me ?

[Anonymous]

Hi  @asbada ,

You can check if the user is in the mapping table, for those who are not in the RLS mapping table, they will not see any data.

In the Service you have to added the users to roles as set up in the dataset security setting.

If you are in the role, but are not in your mapping table, it will return no data.

Please note: for RLS to work, the users must be in the 'Viewer' role at the workspace level. If they are Admin, Member or Contributor, they will be able to see all the data.

Best Regards,

Liu Yang

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

[jdbuchanan71]

@asbada 

Is the RLS working for member of other groups?  If so, RLS is working, otherwise the users would see all the data.  It is just applying a filter that is returning no results. 

There is probably a mis-match in the data somewhere.  In the .pbix file you can replicate the RLS by using the view as under modeling.