How to get Microsoft Teams data from Power BI desktop?

[Ramachandran]

Hi Guys,

I need to get data from Microsoft Teams data like no. of outgoing calls, outgoing call duration, no. of incoming calls, and incoming call duration details based on users to Power BI desktop.
can you suggest to me, how do I get the details?

regards,

Ram

[rajendraongole1 · Accepted solution]

Hi @Ramachandran - you will need to leverage Microsoft Graph API, Power BI connectors, or integrate with Teams' admin reports.

Reference links to extract data from MS Teams to PBI:

How to Analyze Microsoft Teams Data Using Power BI - Monocroft

View Microsoft Teams utilization in Power BI using CQD data - Microsoft Teams | Microsoft Learn

Solved: Connect microsoft teams voice data to power bi. - Microsoft Fabric Community

Use the Microsoft Graph API to work with Microsoft Teams - Microsoft Graph v1.0 | Microsoft Learn

Hope it helps.

[Ramachandran]

thank for your comments,

Is it possible to get the no. of user count (teams), incoming call duration, incoming call count, outgoing call count and outgoing call duration?
if it is yes, what kind of access do I need to get access from Microsoft Teams?

thanks,

Ram

[Anonymous · Accepted solution]

Hi @Ramachandran ,

If you're a Teams or Skype for Business admin, you can use an existing tenant and building data file from the Teams or Skype for Business Call Quality Dashboard (CQD). 

Set up call analytics for Microsoft Teams - Microsoft Teams | Microsoft Learn [ee02-4e4c-0a8-9bb3]

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[rajendraongole1 · Accepted solution]

Hi @Ramachandran - you will need to leverage Microsoft Graph API, Power BI connectors, or integrate with Teams' admin reports.

Reference links to extract data from MS Teams to PBI:

How to Analyze Microsoft Teams Data Using Power BI - Monocroft

View Microsoft Teams utilization in Power BI using CQD data - Microsoft Teams | Microsoft Learn

Solved: Connect microsoft teams voice data to power bi. - Microsoft Fabric Community

Use the Microsoft Graph API to work with Microsoft Teams - Microsoft Graph v1.0 | Microsoft Learn

Hope it helps.