I have three text data files with information about users, AD groups, and servers in this format:
I want to be able to:
-click on a group and see all members
-click on a server and see all groups
-click on a user and see all group names
Is it possible to put this into powerpivot given that the user and server rows are variable length? I'm thinking the data would have to be formatted as
Power Pivot doesn't perform those kinds of transfomations. Power Query does that before the data hits the Power Pivot model.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?