Forum Discussion

santh00's avatar
santh00
Frequent Visitor
3 years ago

Active Directory

Hi all, 

My Requirement is I need to get the list of User, User email and their beloging group in our organization and to show it on a table, I search about it and find the On-Prem Active Directory and Azure Active Directory option, I tried connecting with on-prem active directory using get data method and get user name, user email in one table and user group in separate table am unable to merge two table I didn't find any common column between the table, I find the below article and tried with merging SAMAccount Name but that column values are different for two tables for me is there any other options to go with and I tried with Azure AD as well but I didn't have permission to use Microsoft graph help me any one the above

https://community.powerbi.com/t5/Desktop/PowerBI-to-Query-AD-Group-Memberships/td-p/1590094

Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi santh00 ,

    Do you want to merge 2 tables?

     

    Please try to use merge or append.

    Merge queries overview - Power Query | Microsoft Learn

    Append queries - Power Query | Microsoft Learn

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • santh00's avatar
      santh00
      Frequent Visitor
      3 years ago

      No, I have two tables but didn't find common column to merge tables, My requirement is to get user email and which group they belong to in organization using active directory...I get users and group in two tables but didn't able to merge