topic Re: Get data from teams using microsoft graph api in Developer https://community.fabric.microsoft.com/t5/Developer/Get-data-from-teams-using-microsoft-graph-api/m-p/1932615#M30269 <P>Hi&nbsp;@Anonymous</a>&nbsp;</P> <P>Here is the overview of&nbsp;Microsoft Graph API which work with Microsoft Teams. You can find all API Teams support in it. For reference:&nbsp;<A href="https://docs.microsoft.com/en-us/graph/api/resources/teams-api-overview?view=graph-rest-1.0" target="_self">Use the Microsoft Graph API to work with Microsoft Teams</A></P> <P>For example we get List replies in Power BI.</P> <UL> <LI>ReplyMessages : <A href="https://docs.microsoft.com/en-us/graph/api/chatmessage-list-replies?view=graph-rest-1.0&amp;tabs=http" target="_self">List replies</A>&nbsp;</LI> </UL> <P>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.&nbsp; You may refer to this blog about how to assign permissions:&nbsp;<A href="https://docs.microsoft.com/en-us/graph/permissions-reference" target="_self">Microsoft Graph permissions reference</A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/544707i4FB8D44F354B5E46/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></P> <P>Then you can connect to API by OData Feed connector in Power BI Desktop.</P> <LI-CODE lang="markup">GET /teams/{team-id}/channels/{channel-id}/messages/{message-id}/replies</LI-CODE> <P>To connect to this API, you need to put parameters: team-id, channel-id, message-id into this url.</P> <P>For reference:&nbsp;&nbsp;<A href="https://blog.mydock365.com/microsoft-graph-api-data-on-microsoft-power-bi" target="_self"><SPAN class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" data-hs-cos-general-type="meta_field" data-hs-cos-type="text">How to get Microsoft Graph API Data on Microsoft Power BI</SPAN></A></P> <P><A href="https://community.powerbi.com/t5/Desktop/Get-data-from-Microsoft-teams-shifts/m-p/807676" target="_self"><SPAN class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" data-hs-cos-general-type="meta_field" data-hs-cos-type="text"><SPAN>Get data from Microsoft teams (shifts)</SPAN></SPAN></A></P> <P>&nbsp;</P> <P><SPAN>Best Regards,</SPAN></P> <P><SPAN>Rico Zhou</SPAN></P> <P>&nbsp;</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.&nbsp;</P> Thu, 01 Jul 2021 08:13:33 GMT Anonymous 2021-07-01T08:13:33Z Get data from teams using microsoft graph api https://community.fabric.microsoft.com/t5/Developer/Get-data-from-teams-using-microsoft-graph-api/m-p/1928212#M30216 <P>Hi everyone<BR /><BR /></P><P>I need create a report with data from microsoft teams.<BR />Basically I need to get these data from team.&nbsp;</P><P>I know it is possible to get data from teams using&nbsp; microsoft graph api.</P><UL><LI>ReplyMessages</LI><LI>PostMessages</LI><LI>ChatMessages</LI><LI>UrgentMessages</LI><LI>MeetingsOrganizedScheduledOneTime</LI><LI>MeetingsOrganizedScheduledRecurring</LI><LI>TotalMeetingsOrganized</LI><LI>MeetingsParticipatedScheduledOneTime</LI><LI>MeetingsParticipatedScheduledRecurring</LI><LI>MeetingsParticipatedAdhoc</LI><LI>TotalMeetingsParticipated</LI><LI>1:1 Calls</LI><LI>AudioTime (Minutes)</LI><LI>VideoTime (Minutes)</LI><LI>ScreenShareTime (Minutes)</LI></UL><P><BR />Is there someone that already the same and it can help me to do that?<BR /><BR />Thanks</P> Tue, 29 Jun 2021 12:34:47 GMT https://community.fabric.microsoft.com/t5/Developer/Get-data-from-teams-using-microsoft-graph-api/m-p/1928212#M30216 Anonymous 2021-06-29T12:34:47Z Re: Get data from teams using microsoft graph api https://community.fabric.microsoft.com/t5/Developer/Get-data-from-teams-using-microsoft-graph-api/m-p/1932615#M30269 <P>Hi&nbsp;@Anonymous</a>&nbsp;</P> <P>Here is the overview of&nbsp;Microsoft Graph API which work with Microsoft Teams. You can find all API Teams support in it. For reference:&nbsp;<A href="https://docs.microsoft.com/en-us/graph/api/resources/teams-api-overview?view=graph-rest-1.0" target="_self">Use the Microsoft Graph API to work with Microsoft Teams</A></P> <P>For example we get List replies in Power BI.</P> <UL> <LI>ReplyMessages : <A href="https://docs.microsoft.com/en-us/graph/api/chatmessage-list-replies?view=graph-rest-1.0&amp;tabs=http" target="_self">List replies</A>&nbsp;</LI> </UL> <P>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.&nbsp; You may refer to this blog about how to assign permissions:&nbsp;<A href="https://docs.microsoft.com/en-us/graph/permissions-reference" target="_self">Microsoft Graph permissions reference</A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/544707i4FB8D44F354B5E46/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></P> <P>Then you can connect to API by OData Feed connector in Power BI Desktop.</P> <LI-CODE lang="markup">GET /teams/{team-id}/channels/{channel-id}/messages/{message-id}/replies</LI-CODE> <P>To connect to this API, you need to put parameters: team-id, channel-id, message-id into this url.</P> <P>For reference:&nbsp;&nbsp;<A href="https://blog.mydock365.com/microsoft-graph-api-data-on-microsoft-power-bi" target="_self"><SPAN class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" data-hs-cos-general-type="meta_field" data-hs-cos-type="text">How to get Microsoft Graph API Data on Microsoft Power BI</SPAN></A></P> <P><A href="https://community.powerbi.com/t5/Desktop/Get-data-from-Microsoft-teams-shifts/m-p/807676" target="_self"><SPAN class="hs_cos_wrapper hs_cos_wrapper_meta_field hs_cos_wrapper_type_text" data-hs-cos-general-type="meta_field" data-hs-cos-type="text"><SPAN>Get data from Microsoft teams (shifts)</SPAN></SPAN></A></P> <P>&nbsp;</P> <P><SPAN>Best Regards,</SPAN></P> <P><SPAN>Rico Zhou</SPAN></P> <P>&nbsp;</P> <P>If this post <STRONG>helps</STRONG>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.&nbsp;</P> Thu, 01 Jul 2021 08:13:33 GMT https://community.fabric.microsoft.com/t5/Developer/Get-data-from-teams-using-microsoft-graph-api/m-p/1932615#M30269 Anonymous 2021-07-01T08:13:33Z