Get data from teams using microsoft graph api

[Anonymous]

Hi everyone

I need create a report with data from microsoft teams.
Basically I need to get these data from team. 

I know it is possible to get data from teams using  microsoft graph api.

• ReplyMessages
• PostMessages
• ChatMessages
• UrgentMessages
• MeetingsOrganizedScheduledOneTime
• MeetingsOrganizedScheduledRecurring
• TotalMeetingsOrganized
• MeetingsParticipatedScheduledOneTime
• MeetingsParticipatedScheduledRecurring
• MeetingsParticipatedAdhoc
• TotalMeetingsParticipated
• 1:1 Calls
• AudioTime (Minutes)
• VideoTime (Minutes)
• ScreenShareTime (Minutes)

Is there someone that already the same and it can help me to do that?

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous 

Here is the overview of Microsoft Graph API which work with Microsoft Teams. You can find all API Teams support in it. For reference: Use the Microsoft Graph API to work with Microsoft Teams

For example we get List replies in Power BI.

• ReplyMessages : List replies 

Before you call API you need to make sure you have the permission to the rest api. Each API has its requirement, you can find the permission requirements in Blogs. Now List replies API need one of the following permission to call it.  You may refer to this blog about how to assign permissions: Microsoft Graph permissions reference

Then you can connect to API by OData Feed connector in Power BI Desktop.

GET /teams/{team-id}/channels/{channel-id}/messages/{message-id}/replies

To connect to this API, you need to put parameters: team-id, channel-id, message-id into this url.

For reference:  How to get Microsoft Graph API Data on Microsoft Power BI

Get data from Microsoft teams (shifts)

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.