Forum Discussion

bkim's avatar
bkim
Frequent Visitor
7 years ago
Solved

How do I setup RLS for users to see all data?

I just added in dynamic RLS and it works great for the users who should have the restriction at the row-level. However, I have a few other users who I haven't setup yet and should be able to see all ...
  • dax's avatar
    dax
    7 years ago

    Hi bkim,

     

    If you don’t set RLS  , you could grant them read permission, then they will view all data.

     

    If you want to set RLS, you could create a new role without any filter in it , then add user in that role.

    You could refer to Row-level security (RLS) with Power BI and this post for details.

     

    Or you also could add all records in user table to mapping all data to specific users, then  he/she will get all data.

     

    Best Regards,

    Zoe Zhi

     

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