Forum Discussion
How to query the SQL ReportServer backend to see which reports have RLS or dynamic RLS applied?
Hi everyone,
I'm working with PBI Report Server on-prem. Following up on my previous question - How can I get a csv list of all users who access various reports , I'd like to ask if it's possible to query the backend again to see if row level security has been applied to a certain report or an entire folder or not. Thank you.
2 Replies
pborah , in case SQL server. You should able to see queries on SQL profiler.
amitchandak how is the query profile going to help me? I want to see which reports have RLS applied on the server. This information is probably stored in some table(s) in the backend SQL Server ReportServer database. I want to know if anyone has has done it before and queried the backend to pull this information into rows and columns.
