Forum Discussion
damianmayer
6 years agoNew Member
Use Teams Group members as a datasource
I need to produce a report which shows the location (Globally) of the members of a Team.
I can extract the members of the Team and associated data using Powershell
Get-AzureADGroupOwner -all 1 -ObjectId "ObjectID" | Export-csv -path C:\Temp\teammembers.csv
But getting this updated regularly is a pain. How can I connect DIRECTLY to this group from Power BI so that I can have my report upto date whenever new members are added - I'm happy with the resulting data source being updated daily.
My issue is how to I create or connect to hte Azure AD group underlying the team from Power BI to use the list of members as the dataset?
1 Reply
- v-gizhi-msft
Community Support
Hi,
Hope this can help:
Best Regards,
Giotto Zhi