Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic RLS does not work in Service

Hi,    I have set up dynamic RLS in Power BI Desktop and it works perfect in PBI Desktop. The RLS table has a M:N relationship and filters in both direction. Also all persons are member of the work...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    The main reason RLS doesn't work is because the person viewing the report has edit access to the dataset. Double-check that your viewer is a member of the workspace or has edit permissions for the report.


    If possible, you can upload the report to another new workspace for testing.


    Please note if the relationship requires the cross-filter direction to be both directions (two-way cross-filtering), ensure that the Apply Security Filter Bidirectionally option is enabled for RLS to work properly.
    In addition, you can refer to this document to check the restrictions on RLS.

     

    You can refer to the following documents that may be helpful to you:

    RLS issue - on Power BI service (when Test as a Role) | Power BI Exchange (pbiusergroup.com)

    Dynamic RLS In Power BI | Microsoft Gold Partner | Addend Analytics

     

    Best Regards,

    Neeko Tang

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