Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to Identify what groups a user is a member of. Currently I have exported from AD all group details into CSV and then loaded into Power BI. The table consists of 4 Columns, Name, Category, Scope and Members. Members contains the comma seperated samAccountNames of all members of the group.
The end goal is to be able to slice by User, Manager, or Dept, to identify common groups. What would be the best way to accomplish this?
I appreciate any assitance provided.
Solved! Go to Solution.
I'd use Power Query to clean the data - split the members column at each instance of the delimiter, then pick the other three columns and unpivot the rest
I'd use Power Query to clean the data - split the members column at each instance of the delimiter, then pick the other three columns and unpivot the rest
This did exactly what I was looking for. Thanks for the answer.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |