Forum Discussion
Row Level Security in Power BI Paginated not working
Hi GilbertQ
I spoke to MS Support and they told me that currently, this is not possible. They quoted this article (https://docs.microsoft.com/en-us/power-bi/developer/embedded/paginated-reports-row-level-security#use-userid-as-a-filter-at-report-or-query-level). Really weird location for a paginated reports limitation, don't you think 🙂
The product team is currently working on enabling this and it should be coming in the next semester ( 6 months ) but they don't know when exactly.
For now, I am passing the UserID system variable to my queries and applying the RLS logic in the DAX queries. It's doing to job for me while I wait for a solution.
Thanks for the assistance though!
Regards,
Georgi
GilbertQ, thanks but I have thousands of users, and managing it from here would be a living hell, so I would need to find another solution. Is anything else coming up to your mind?
- GilbertQ
Super User
Hi george_p
The only other way is to make some changes on the Gateway, but in order to do that you would also have to make changes to the Active Directory user accounts to add in their email addresses to an un-used property.
Unfortunately there is no easy work around.
The only other option is to use AAS or Power BI Premium or Power BI Premium Per user.
