cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

API call for Teams usage

Without the GraphAPI connector in PBI, we have to build web api calls to fetch teams usage data from scratch.

 

What would be the API call to fetch usage by Team?

 

This is the call to fetch the usage by user (https://graph.microsoft.com/beta/reports/getTeamsUserActivityUserDetail(date=YYYY-MM-DD)), but a user can belong to many teams, so we are unable to summarize from this content.

 

s-roberts_3-1597408138081.png

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

HI @s-roberts ,

I checked the official document but not found the api that shows each record without any aggregate.
Perhaps you can try to access the admin portal to confirm if any export feature that allow you to export the detail user activity logs.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

"a user can belong to many teams, so we are unable to summarize from this content"

 

Please elaborate.  You can run multiple API calls in Power Query and then combine the results.

Highlighted

 

The mentioned call provides an activity count by user and by day (not broken down by team).

When a user belongs to multiple teams, it would not be accurate to apply all the activities to each team. We'd need the portion of that activity that applies to each team. 

Is there another call that would already have acitvity counts by team and by day (and possibly by user). 

Highlighted
Community Support
Community Support

HI @s-roberts ,

I checked the official document but not found the api that shows each record without any aggregate.
Perhaps you can try to access the admin portal to confirm if any export feature that allow you to export the detail user activity logs.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors