Forum Discussion
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 ...
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.
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