Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |