Forum Discussion
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.
8 Replies
Hi MJG2112 , I have built a solution based on the fabric to address this .
Semantic Link - Model Health & Security Suite : Please take a look at it
Thanks
If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.
For more Power BI tips and discussions, let’s connect on LinkedIn:
https://www.linkedin.com/in/natarajan-manivasagan
Cheers!Thanks, but this looks to be way more than I actually need.
You can also use standard DMV queries to get that meta data.
My reading has highlighted that DMV alone is insufficient for my use case. It will only give me the RLS roles and DAX filters. I would need to use APIs to get the user associated with those roles. A different option that’s been suggested to maintain a governance SharePoint file for the users, but this seems counterintuitive. In order to build that I need to examine every role in every report to see who the users are, which is the problem I’m trying to solve!
I would need to use APIs to get the user associated with those rolesIs 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
