Forum Discussion

damianmayer's avatar
damianmayer
New Member
6 years ago

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?