Forum Discussion

MJG2112's avatar
MJG2112
Advocate II
4 months ago
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?
  • lbendlin's avatar
    lbendlin
    4 months ago

    How about two easy DAX queries?

     

    EVALUATE
        INFO.ROLES()
    EVALUATE
        INFO.ROLEMEMBERSHIPS()
     
    That can be run against the semantic models in your workspace, from any place that can run DAX.