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.
You can create an "Admin" role with no filters for users who should have full access.
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?
tespinalexactly right. No role = no data. No-filter role = all data. Filtered role = filtered data.
Got it. Thank you very much for all of your help!
You're welcome.
Now, if only I could figure out how my RLS has managed to somehow filter the results from one column of a table without filtering those same rows in any other column. That shouldn't even be possible...