How do I create custom reports in Microsoft Teams?

Question

Microsoft

Hello.
I need to organize a series of reports in Microsoft Teams on a regular basis. The Analytics & reports section (Microsoft Teams admin center) has almost all the necessary information about the activity of users and teams. But this information should be presented in such sections, based on the properties of users, which are not here.
But they are in the data uploaded from Active users to the Microsoft 365 admin center.
As a result, I am forced to export two csv files and create a report based on two tables already on the local machine.
Something tells me that this is far from ideal.
Office 365 cloud apps include both Excel and PowerBI. Is it possible to do all the reports right in the browser, dynamically updating some links/data in Excel or PowerBI? How to connect to the necessary information?

Answer 1

Everything that is according to the reports can be seen here , and the TP answers in more detail in the service.