Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

Dynamic Row Level Security

Hi guys,   Need some advice as I got strange behaviour while testing Row Level Security.  So I create these data :     And my Relationship is like this :   Then created Role, and ...
Need Help
  • TomMartens's avatar
    TomMartens
    5 years ago

    Hey admin_xlsior ,

     

    I assume that you are accessing the content via a workspace and that you have one of these 3 roles assigned contributor/member/admin.

    This means that no RLS is applied.

     

    only members that have the viewer role assigned will experience the RLS when accessing content from inside a workspace.

     

    My recommendation, get a second user (assign a Pro license, if you are not working with Power BI Premium) and test RLS using this user by accessing content from inside an App.

     

    Hopefully, this provides some ideas on how to tackle your challenge.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
5 years ago

Hey admin_xlsior ,

 

I assume that you are accessing the content via a workspace and that you have one of these 3 roles assigned contributor/member/admin.

This means that no RLS is applied.

 

only members that have the viewer role assigned will experience the RLS when accessing content from inside a workspace.

 

My recommendation, get a second user (assign a Pro license, if you are not working with Power BI Premium) and test RLS using this user by accessing content from inside an App.

 

Hopefully, this provides some ideas on how to tackle your challenge.

 

Regards,

Tom

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago

Hi Tom,

 

How to check those roles ? contributor/member/admin.

But yes, I'm the only one in my domain, so it is admin.

 

Thanks