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.

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,toDateTime=2024-09-13) 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