Active Directory

[santh00]

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

[Anonymous]

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]

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