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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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,

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors