Forum Discussion

daniel_w's avatar
daniel_w
Frequent Visitor
5 years ago
Solved

Power BI Row Level Security - Cannot Load Model

Error: User is trying to access model with id=xxxxxx which has cloud RLS enabled, but they have no roles associated with them.   Background: I added a user to a Row-level security group. It works...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi daniel_w 

     

    When you have RLS configured you would need to create an Admin role or a role without any restrictions to allow certain users to see all the data.

     

    Another option you could do is to give the user a member role in the app workspace that is anything but a Viewer Role. This too would allow them to see all the data.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi daniel_w 

 

When you have RLS configured you would need to create an Admin role or a role without any restrictions to allow certain users to see all the data.

 

Another option you could do is to give the user a member role in the app workspace that is anything but a Viewer Role. This too would allow them to see all the data.

  • daniel_w's avatar
    daniel_w
    Frequent Visitor
    5 years ago

    Thanks Gilbert!

     

    This confirms my current solution. I actually had to create a role with no restriction and add the person into this new role.

     

    Which mean with RLS configured, everyone had to be in a role, unless the person is an admin (or a member in workspace)?

     

     

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      5 years ago

      Yes that is correct