Jordan on 13 Jun 2019 23:10:43
Having XMLA end points for all my models in Premium Capacity is great since I can query those models via DMVs to create data dictionaries, relationship diagrams, etc. However, a huge missing piece is being able to query role memberships. I can see the roles, can see the DAX expression used by those roles, but I cannot see the users assigned to each roles. I would like to be able to see the users to audit RLS across all of my models.