Forum Discussion
Solved
How Can I Access the RLS Data in a Semantic Model and Report on it?
I want to produce a report showing the RLS roles and the users assigned to them for all the reports in our workspace. How can I access this data and report on it?
How about two easy DAX queries?
EVALUATEINFO.ROLES()EVALUATEINFO.ROLEMEMBERSHIPS()That can be run against the semantic models in your workspace, from any place that can run DAX.
I would need to use APIs to get the user associated with those roles
Is that not viable for you? Are you looking for a ready-made auditing solution? If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com
I have no experience with either DMV or APIs for this problem.