Forum Discussion

tespinal's avatar
tespinal
Frequent Visitor
9 years ago
Solved

row level security

Good Afternoon, I was testing out RLS with my supervisor today. I added her to my role and checked to verify everything was working. I then removed her from the role and everything errored out. I as...
Need Help
  • tespinal's avatar
    tespinal
    9 years ago

    Update:

     

    I was able to solve the problem by pulling everything down from the affected report from Power BI online (dashboard, report, and dataset). When I republished the report after doing that, everything worked as normal. 

  • Anonymous's avatar
    Anonymous
    9 years ago

    tespinalexactly right. No role = no data. No-filter role = all data. Filtered role = filtered data.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

You can create an "Admin" role with no filters for users who should have full access.

tespinal's avatar
tespinal
Frequent Visitor
9 years ago

Fantastic! Thanks. That is going to help immensly. I'll need to create several roles in the near future. So if I create a limited role, then I need to assign a role to everyone whether or not they are in the limited role group? I.E if I create a limited role, then anyone I share a dashboard with will not see anything until I assign a role to them like the admin role?