Forum Discussion

pjilek's avatar
pjilek
New Member
6 years ago
Solved

Active Directory report for all groups with users

I would like to generate a report for all my active directory (win2012 on prem) groups, with users in each group.  I can easily get the BI source data for the group and the users, but I cannot figure out how to associate the two data sources. Format such as;

Group 1- user1

               -user2

               User 7

Group2-user5

               -user3

Any hints would really help.....

Thx pj

Need Help
  • pjilek's avatar
    pjilek
    6 years ago

    I see I have more issues with table data, I need a membership table data to tie all together.  I will continue to search, thanks anyways guys.

    thx pj

5 Replies

    • pjilek's avatar
      pjilek
      New Member
      6 years ago

      same BI data source-active directory

      I selected table- group

      I selected table- user

      If there is a better way, I am open to anything.

      thx pj

      • pjilek's avatar
        pjilek
        New Member
        6 years ago

        I see I have more issues with table data, I need a membership table data to tie all together.  I will continue to search, thanks anyways guys.

        thx pj

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    6 years ago

    pjilek  You can combine multiple tables into one table provided your columns are same in all the tables. In power query window, you will get option to append query.

     

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    pjilek , It not very clear. Can you share sample data and sample output in a table format?

    Like what is challenge in association