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.
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...