Help with PSTN Direct Routing Calls into Power BI

[JMG241188]

I have wracked my brains trying to figure this out, and there isn't much help out there.

I have a report within the Teams Admin Centre that is showing plenty of PSTN Direct Call usage over the course of the last 28 days. This is fine, but I want to pull this data into PowerBI.

I have already Used the CQD connector and this direct import does not have caller or callee ID and is you cannot amend the query editor or link in with exisiting reports.

I have crated a Microsoft Graph Azure App, with mixed results, the "https://graph.microsoft.com/v1.0/communications/callRecords/" request only brings me back results for the last 24 hours, but only for PeerToPeer and GroupCalls, which is not what I want.

I have tried to link up https://graph.microsoft.com/beta/communications/callRecords/getPstnCalls but this open API without dates returns an error, the documentation online says that it needs a date filter, which I have also tried; https://graph.microsoft.com/v1.0/communications/callRecords/getPstnCalls(fromDateTime=2024-06-23,toD... which returns a successful response, but with 0 results; 

Does anyone know where I'm going wrong here, as I feel like I'm going round in circles now.

Any help would be greatly appreciated.

Thanks,

Jon

[JMG241188 · Accepted solution]

I have solved the issue around the API call, the URL is dor DirectRouting Calls

[Lakshya1811]

Could you please explain how did you do it? I am stuck at the same place

[JMG241188]

API URL is https://graph.microsoft.com/beta/communications/callRecords/getDirectRoutingCalls

As opposed to https://graph.microsoft.com/beta/communications/callRecords/getPstnCalls

https://learn.microsoft.com/en-us/graph/api/callrecords-callrecord-getdirectroutingcalls?view=graph-... 

[MNedix]

Have you tried an intermediate step/system to dump the data into and then fetch it with PowerBI? In the past, I worked with systems I couldn't connect directly with PowerBI but I was able to either program their API or have the system itself to dump the data into a storage, be it a SQL DB or .csv in shared folder. It was a walk in the park after that even though I had to keep an eye on the intermediate system.

I hope it helps.

Best,

[JMG241188]

Seems a bit crazy to me that 2 Microsoft products don't have more straight forward compatibility, surely I'm not the only person who wants this?