Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
"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.
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
2 | |
2 | |
2 | |
2 |