How can I connect Microsoft Teams (quantity of messages) of all my users organization to PowerBI?

[brunozanoelo]

Hello!

How can I connect Microsoft Teams (quantity of messages) of all my users organization to PowerBI? It is possible? Any Idea!? It´s a nice project to work with 🙂

I am the Administrator of the our domain, so I have all permissions to do that.

Best  Regards!

[Poojara_D12]

Hi @brunozanoelo 

To connect Microsoft Teams message quantities to Power BI:

• Use Microsoft Graph API: Query Teams message activity via endpoints like /reports/getTeamsUserActivityCounts(period='D30').
• Set Up Azure AD App: Register an app in Azure AD, grant Reports.Read.All permissions, and authenticate via OAuth2.
• Pull Data into Power BI: Use the Web connector in Power BI with the API endpoint.
• Schedule Refresh: Automate data updates in Power BI Service.
• Visualize Data: Build custom dashboards to analyze message activity.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[lbendlin · Accepted solution]

Use the Graph API   (and Web.Contents)

Working with Microsoft Teams messaging APIs in Microsoft Graph - Microsoft Graph | Microsoft Learn