Export Teams Call Quality Dashboard to SQL server

Sayali-MSFT 

Basically, Teams keeps the current CDRs only 30 days available. If you want to create any kind of statistics which are older than that, e.g. see PSTN calls, Queue reports, from last months, you should have access to that data longer then 30 days (e.g. for 365 days).

So the idea behind this was, to export available data from O365 and import that into e.g. SQL database. And then having e.g. Power BI templates for users.

This also solves even the bigger issue, to be able to read those CDRs from O365 you need to have quite much access to it which we cannot give for regular users. Having separated SQL DB we could segmenting what end users are able to see from their own calls. And that they can do using their own credentials.

On the Power BI we are able to use "Microsoft Call Quality" as a source, so I though using similar method. I could perhaps setup a process for doing the same in automatically, and importing the data into SQL. But before that I thought to ask from here, if anybody else has already been working with this.