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

lbendlin Perfect.  Just what I need.