MySQL PowerBI Reporting

[ESP Projects]

Hi all,

We have quite a few customers running v20 update 8. We want to provide many of them with PowerBI reporting, but we want the data to be offset in MySQL for technical reasons not relevant here. The PowerBI reports that have been provided so far relate to Microsoft SQL. Our question is, has anyone yet ported these templates into a format that works with MySQL rather than Microsoft? PowerBI fully supports MySQL so there's no reason it won't work, we were hoping that 3CX might provide them in all database formats really. https://www.3cx.com/docs/power-bi-reports/

Thanks

 

[Evolute IT]

Hi all,

We have quite a few customers running v20 update 8. We want to provide many of them with PowerBI reporting, but we want the data to be offset in MySQL for technical reasons not relevant here. The PowerBI reports that have been provided so far relate to Microsoft SQL. Our question is, has anyone yet ported these templates into a format that works with MySQL rather than Microsoft? PowerBI fully supports MySQL so there's no reason it won't work, we were hoping that 3CX might provide them in all database formats really. https://www.3cx.com/docs/power-bi-reports/

Thanks

The templates use PowerBI Desktop, which is different from the webapp. The desktop app requires MSSQL, and does now allow for MySQL.

 

[KyriacosS_3CX]

Hi,

The Grafana templates include MySQL, and those queries should be transferable with some work to other visualisation engines.

There is to a large extend and 1-to-1 equivalence between the Grafana and PowerBI Dashboards, but some differences in how data is fetched will exist.

 

[ESP Projects]

Has anyone already ported them into a MySQL PowerBI template set?