Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
JMG241188
Helper I
Helper I

Help with PSTN Direct Routing Calls into Power BI

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.

 

JMG241188_0-1726221760226.png

 

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; 

 

JMG241188_1-1726222000056.png

 

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

 

1 ACCEPTED SOLUTION
JMG241188
Helper I
Helper I

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

View solution in original post

3 REPLIES 3
JMG241188
Helper I
Helper I

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

MNedix
Super User
Super User

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,



If the post helped then please give it a Kudos and mark it as the solution so others can see it.
Cheers,

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?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.