Microsoft Teams Classrooms Insights API

Question

We are trying to adopt Teams classrooms and Education Insights in our school. I want to somehow automate the process of retrieving data about students' performance within the classroom. So far I can retrieve a static excel file with such data using the "Export to Excel" functionality. But it is incredibly time consuming for a teacher to process hundreds of excel files, as mentioned from this post addressing the same issue (https://answers.microsoft.com/en-us/msteams/forum/all/microsoft-teams-classrooms-insights-api/b29ff42b-caf8-4768-9c02-fa11ca2888ec). Is there an API for Educational Insights that I can use as a data source for a Power BI report or something like that? Or A flow in PowerAutomate that retrieves data from Insights? I have not tried much yet but I am thinking about RPA to automate the process of retrieving those excel flows if needed, but I would rather try everything before I resort to that.

Answer 1

Hello AdKs,

My name is Oluwatosin and I’ll be more than happy to help you with your query." This is a user-to-user community forum. We do not have access to your account.

If you are looking to automate data retrieval from Microsoft Teams for Education Insights, check out the education APIs available in Microsoft Graph.

Refer to: https://learn.microsoft.com/en-us/graph/education-concept-overview

You can also reach out in the community page: https://learn.microsoft.com/en-us/answers/tags/161/ms-graph

I hope this helps! Let me know if need further assistance.

Best regards, Oluwatosin.