Get and visualize GROUP MEMBERS & OWNERS with Power Automate & Power BI
This video demonstrates how to use Power Automate and Power BI to get and visualize group members and owners. It works for M365/Teams groups, Azure AD groups, and distribution groups. The video covers creating a scheduled Power Automate flow, pagination for large queries, getting all group owners in the tenant, connecting to the data in Power BI, creating a link to manage users in Azure, relating the groups to the members, and visualizing the data. It also showcases dynamic row-level security for group owners. This tutorial is helpful for auditing membership, cleaning up stale groups, and gaining visibility into group data.
Video 17m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time