The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
181 | |
82 | |
63 | |
47 | |
43 |