Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Azure Directory Group in Data Model

Hello All, I am wanting to establish RLS in my embedded powerbi app. Is it possible to query an Azure Active Directory Group to show usernames and any attributes i want? Say Email, Organization?

This way I dont have to maintain the users and roles in a seperate datamodel all together

 

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    Yes, there is an ActiveDirectory data source connector in Power Query, and you get to all these attributes.  Just be aware that it might be a tad slow depending on the size of your AD, so better test that the performance is acceptable before you go that route.

     

    Once you involve a gateway you have the additional issue that the gateway connection user needs to have sufficient permissions to access AD.