Forum Discussion

PaulaL's avatar
PaulaL
Frequent Visitor
7 years ago

active directory Field Location

Hi, I am trying to compose a new desktop report showing the following information from Active Directory.

 

The Security Group, Who all is a member of this group and finally who has Group Membership.

 

I was able to locate the Security Group and which users have access to these groups but I have been unable to identify th Group Membership (which is under the Member of tab)

 

Any help would be greatly appreciated.

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi PaulaL ,

    You can consider to use powershell to export all member information then use power bi get data from exported file and create report.

    Regards,

    Xiaoxin Sheng

    • PaulaL's avatar
      PaulaL
      Frequent Visitor
      7 years ago

      Hi Anonymous , I was able to export the information out through another tool but ideally we would like to pull it direct from source to stop us having to use additional excel sources and then modifying the excel sheet to make it fit the relevant template, ideally we would like to make it a more automated process.

      Thanks
      Paula

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        HI PaulaL ,

        Nope, this is impossible. Power bi AD connector user account to get data from active directory. Current it not support connect multiple accounts in same report.

        Regards,

        Xiaoxin Sheng