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
Super UserHi george_p
I could not see anything in the limitations here: What are paginated reports in Power BI Premium? - Power BI | Microsoft Docs
The only thing I could think of is it is not passing through the details correctly to your SSAS Instance? Have you mapped the usernames?
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 for letting me know, I was not aware of this limitation!