Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Is there someone that already the same and it can help me to do that?
Thanks
Solved! Go to 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.
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.
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.
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.