Forum Discussion
Paginated reports row level security
Hi All, We have started using paginated reports within powerbi service recently. Our data source is Azure sql server. We are looking for a way to have row level security in paginated reports. The use...
RLS is available if you're using Azure Analysis Services or Power BI datasets. Azure SQL database will support RLS by the end of June
If RLS is supported in Azure AS, why isn't supported in SSAS? (I presume we're talking about using RLS with Paginated Reports)
Because of the gateway, essentially. There's work we need to do to go and enable that and what we did for Azure AS couldn't be directly translated back to on-prem because of the Gateway work. It's still planned, and you can use the technique outlined here to still enforce row-level permissions in an on-prem AS instance today - https://docs.microsoft.com/en-us/power-bi/guidance/report-paginated-data-retrieval
Chris