Forum Discussion
row level security
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.
tespinalexactly right. No role = no data. No-filter role = all data. Filtered role = filtered data.
After publishing, you have to go to the dataset's Security settings and add each user to their role there. Sharing alone is not enough with RLS.
Thank you for the feedback. My issue is when I wanted to remove her from the role and grant her full access again. When I tried to reshare the dashboard, it didn't let her see anything.
If you aren't assigned any role you won't see anything.
Understood, thanks for the tip. That will be helpful when I create future roles.
You can create an "Admin" role with no filters for users who should have full access.