Analyze your Teams Direct Routing/Operator Connect PSTN calling details using PowerBI

Microsoft Teams stores Direct Routing, Calling Plans, Operator Connect, and Audio Conference Dial-Out call details. The report is stored for 7, and 28, or you can use custom dates to filter the data that you are looking for.

Today, there is no easy way to analyze these reports in TAC. However, you can download the report in CSV format and upload it to PowerBI to get a better analysis report.

Login to Microsoft Teams Admin Center and navigate to "Analytics and Reports" and select "Reports". In the report section select "PSTN and SMS Usage Report" / Audio Conferencing dial-out usage, generate the report, and export the report to CSV format.

Once you download the CSV file you can upload it to "PowerBI"

Once you uploaded the data, you can validate/confirm the dataset and required tables are available.

Select the bar chat for visualization and select "DestinationContext" on the y-axis and "Total Call Duration" on the x-axis (sum the total duration value).

Create similar visualization for different datasets e.g total call type by user location.

Audio Conferencing Dial-Out Usage report: -

Direct Routing Usage report: -

Operator Connect/Microsoft Calling Usage report: -