PSTN Usage Report - export / view via PowerBI or thru API

We would like to provide automated reports to our managers which contain data gathered from PSTN Usage reports. Specifically individual call statistics for users (inbound / outbound). At the moment, one will need to go to the admin center and view this manually or extract / export via Excel.

Please provide the capability to mine / query these data using PowerBI or API

90 votes

Anonymous shared this idea · Nov 11, 2019 · Flag idea as inappropriate… · Admin →

12 comments

An error occurred while saving the comment

Leigh Dastey commented · September 21, 2020 4:34 AM · Flag as inappropriate

This feature would be beneficial to our organisation to. I had just assumed I could do this but after trying and going through support it seems I can't.

Upvoted!

Submitting...
Anonymous commented · July 30, 2020 2:19 AM · Flag as inappropriate

There is a Graph option for direct routing and PSTN report now (beta) - https://docs.microsoft.com/en-us/graph/api/callrecords-callrecord-getpstncalls?view=graph-rest-beta

Submitting...
Rob Chambers commented · July 1, 2020 7:19 AM · Flag as inappropriate

Also, as part of this we need the Direct Routing report to be included! Considering how much money this generates for Microsoft (in calling plans, on top of 365 licensing) I'm surprised this is not already available!

Submitting...
florian deckert commented · June 26, 2020 2:47 AM · Flag as inappropriate

mandatory to efficiently manage pay-per-minute usage. The existing msgraph API is incomplete and lagging days behind real-time usage.

Submitting...
Jeffrey Bryner commented · April 20, 2020 11:21 AM · Flag as inappropriate

We and our clients need it as well. Especially given that Microsoft deprecated the original function (Get-CsPSTNUsageDetailReport) it and did not replace it with anything. Graph is the logical platform/capability to deliver this and....

Ref: https://techcommunity.microsoft.com/t5/Office-365-Blog/Announcing-the-General-Availability-of-Microsoft-Graph-reporting/ba-p/137838

Submitting...
Frank Looijesteijn commented · April 16, 2020 5:12 AM · Flag as inappropriate

Scheduling Teams reporting is a standard feature of MAF ICIMS reporting for Teams. Reports can be scheduled on every our of the day, week, month however you like and be send in .pdf . word. .csv. xlsx. For more info or demo: https://www.mafinfo.com/demo-or-free-trial/

Submitting...
Anonymous commented · March 24, 2020 6:59 PM · Flag as inappropriate

We really need this feature as well - important to our road-map as increasingly users are out-bounding from teams so we want to capture that aspect of activity.

Submitting...
Anu commented · March 12, 2020 9:21 AM · Flag as inappropriate

Please add this feature.....

Submitting...
Anonymous commented · March 9, 2020 1:34 PM · Flag as inappropriate

We need this badly, please add this feature

Submitting...
Mike Muniz commented · January 30, 2020 10:52 AM · Flag as inappropriate

We truly need this functionality in our organization as it will aid in our leadership reporting.

Submitting...
Zach Mccain commented · January 17, 2020 7:35 AM · Flag as inappropriate

I second this as we would like to be able to perform usage (duration) data per device. For instance, how often was the tele-con system associated with this phone# utilized in a given period. Should be query-able via Graph API ideally.

https://stackoverflow.com/questions/59761968/is-there-an-ms-graph-api-end-point-to-retrieve-microsoft-teams-pstn-and-sms-usag/59782397#59782397

Submitting...
Anoop Nair commented · January 17, 2020 7:33 AM · Flag as inappropriate

It would be great to add this to to the Teams Report Graph API.

Submitting...