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 users have been added in different AD groups as per their roles and access levels. Could someone please advise what options i could try to filter the data based on the powerbi service login ? And how do i pass the powerbi service login to database ? Or please suggest some other ways to achieve RLS in paginated reports.
Thanks,
Shanawaz
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 users have been added in different AD groups as per their roles and access levels. Could someone please advise what options i could try to filter the data based on the powerbi service login ? And how do i pass the powerbi service login to database ? Or please suggest some other ways to achieve RLS in paginated reports.
Thanks,
Shanawaz
9 Replies
Hi shanawazsheriff ,
Current RLS only works on report server or database side, you can't enable RLS on paginated report.
For your requirement, you can submit an idea for this requirement.
Regards,
Xiaoxin Sheng
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
Yes, you should be able to use oAuth and check the box for users to connect under their identity. It's covered in the documentation - https://docs.microsoft.com/en-us/power-bi/paginated-reports-data-sources
