Forum Discussion

Deleted's avatar
Deleted
Feb 04, 2020

Microsoft has released 6 Power BI Reports for Microsoft Teams Call Quality Dashboard (CQD)

 

Good news, Microsoft has released 6 really useful PowerBI.com reports that connect to Call Quality Dashboard data.

 

You can download them here: https://github.com/MicrosoftDocs/OfficeDocs-SkypeForBusiness/blob/live/Teams/downloads/CQD-Power-BI-query-templates.zip?raw=true

 

I did a quick blog overview of what's in them and how to make them work here:

 

https://tomtalks.blog/2020/02/6-power-bi-reports-for-microsoft-teams-call-quality-dashboard-cqd/

 

Thoughts, questions and feedback welcome!

 

 

CQD
PowerBI

6 Replies

  • Ted17's avatar
    Ted17
    Copper Contributor
    Feb 05, 2021

    Deleted 

    Great job! Thanks!

    I was wandering about conferencing counts, it looks like it's just a total call count client:server and not a real count of meetings (that you can find in Usage report in Teams admin center). For the same meeting ID with 5 participants we will have 5 counts. Or I am wrong?

     

     

  • David Phillips's avatar
    David Phillips
    Iron Contributor
    Jan 25, 2021

    I've been trying to use these reports, but I've found that the performance is very slow.  For example, if I open any of the reports, it can take up to two minutes for the report to fully populate data.  Have others found the same?  If so, I'm wondering what you've done to resolve.  

  • DanDorgan's avatar
    DanDorgan
    Copper Contributor
    May 12, 2020

    Deleted

    Brand new to PowerBI, I just downloaded the GitHub zip file  It is in a PBIT format vs. PBIX. I get as far as the workspace creation and add files dialog. Any attempt to upload the data fails. What is the difference between the sources?

    • Cristian Popa's avatar
      Cristian Popa
      Copper Contributor
      May 13, 2020

      DanDorgan you can use Power BI desktop load the pbit file and after you select publish and you can save as pbix. 

  • matisoca's avatar
    matisoca
    Copper Contributor
    Mar 27, 2020

    Hello Deleted ,   PowerBI are fantastic..  Give us different views that we cannot achieve on Teams CQD.  

    We have noticed that reports always show the same data for Wired and WiFI records. Is there something we have to adjust?

    Thank you,
    Matias

  • Deric Soong's avatar
    Deric Soong
    Copper Contributor
    Mar 27, 2020

    Hi Deleted ,

    Great sharing. I have been waiting for these so long.

    I managed to download and uses these new PowerBI reports.

    Anyhow, when I compare the data with CQD, the numbers have huge differences.

    Am I suppose to perform any kind of configuration?

    Thanks and stay safe.

Resources