PowerBi Reports for V20 U7

[uhpadmin]

I have been trying to see if there are any PowerBi reports available for the new update 7.
With the ability to push data to a SQL server, I would like to see what reports can be built.
I built some reports using the CDR log files, but the new logging format seems to have changed a lot.

If anyone has any templates or suggestions, it would be greatly appreciated.

 

[VoIPTools]

The new Grafana integration can push a limited amount of information to PostgreSQL, SQL Server, and MySQL, and Google Bigdata (if I remember correctly). The new table provided by 3CX has additional information (compared to the original CDR files) you can use to create reports:

https://www.3cx.com/blog/releases/u6-call-data-records/

The good news is that the original CDR files are still available and have not changed. Your old PowerBi reports will still work. Depending on the data you want to display in your new reports, the original CDR data may still provide a gloriously simple data source you can use to make your reports. If you want to make more complex reports, take a closer look at the new table (see link above).



If you want access to even more data -- easy access to queue statistics, queue login/out times, recordings, chat history, and more, consider taking a look at our 3CX Exporter for an automated service, like 3CX's automation, but includes all the 3CX data, including the new table, and the original CDR files, replicated on the schedule you define.