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!Annoucement: Office 365 Call Quality Dashboard updates (Dec 2017)
Hi, I'm happy to announce that we have updated the Call Quality Dashboard (CQD) for Skype for Business Online and Microsoft Teams with two new features based on user feedback: 1. Support for Report Reader role for access to CQD Users assigned to the Report Reader role in Office 365, can now view and create reports in CQD. Users assigned to this role will not be able to upload new building mapping data. This role also enables access to the User Activity reports in the Office 365 admin center. More information can be found in this blog and here. 2. Reliability issue report We have added reports that show the percentage of calls that fail to setup due to IP blocking policies and deep packet inspecting (DPI) on the network path to Office 365. Typically these failures happen when the network equipment or policies are not correctly configured to support access to the IP addresses and ports used for Microsoft Teams and Skype for Business. More information about the address and ports needed is located here. To access these reports, select "Reliability" in the drop down on the top bar. These reports show the Firewall DPI media failure percentage and Firewall IP blocked media failure percentages for Audio, Video, Application Sharing and Video Based Screen Sharing modalities. Note that the denominator for these percentages is the number of streams we have corresponding call detail records for (Total CDR Available Stream Count). These reports include a filter on Second Inside Corp dimension that allows you to select All (No filter), Inside or Outside. This is based on the mapping of client subnets to sites in the building mapping data. There will be updates to the documentation about these new reports coming in the next several weeks. We happy to listen to any feedback about these new reports and the role. thanks, /william
Troubleshooting Lync Call Quality Locally with Snooper
First published on TECHNET on Dec 07, 2012 Have you ever wanted to figure out why a user experienced poor call quality, but didn’t have access to the Lync Sever Monitoring Server reports to dig into the data? This article shows you how to use UCCAPI logging, Snooper, and XML Notepad to log, review, and analyze call data, when Lync Server 2010 or Lync Server 2013 monitoring reports aren’t available.
Teams CQD for Power BI (QER 4.9)
Public service announcement, the Power BI templates for Teams Call Quality Dashboard have been silently updated. The QER template in the pack has been updated to 4.9. I follow Matt Wade's GitHub (GitHub - MattWade-MS/QER: Repository for CQD templates) but nothing new has been posted there in a while. Anyway, the package was updated on 2/7/2024 (Download CQD Power BI Query Templates from Official Microsoft Download Center) and the release notes for QER 4.9 are: V4.9 The following updates/issues were addressed in this version. Search Search page has been updated to include Teams Events. Filter for Meeting Type added to make it easier to find Teams Events. Drill through to Event Health Details added. Teams Events Overview New Teams Events Overview report includes information about the Teams Events usage, includes a quick view of Events hosted in the last 7 days. Event Health Details Drill through report for Teams Events includes information on both Presenters and Attendees. VDI Clients New report for users on VDI clients. New Teams Usage New Teams client usage report for Mac and Windows. Other General fixes to PSTN reports to address changes in telemetry. Fixes to some of the formulas.CQD Urgent help required
Hi -End Goal is to import CQD call and stream volumne by minute for a limited number of second reflective ip networks to sql so any suggestions on this would be fab. However current issue is I am trying to use the following power query to import data from CQD to power bi which runs without error in the power query window and displays the expected results... when i try to apply changes in power bi i get the error message below /* Copyright 2020 Microsoft Corporation Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. */ let Query1 = let Source = MicrosoftCallQuality.GenerateTable(null, null), #"Filtered Rows1" = Table.SelectRows(Source, each [Second Reflexive Local IP Network] = "xx.xxx.xxx.x" or [Second Reflexive Local IP Network] = "xx.xxx.xxx.x") in #"Filtered Rows1", #"Removed Other Columns" = Table.SelectColumns(Query1,{"End Time", "Year", "Second Reflexive Local IP Network", "Audio Stream Count", "Audio Call Count", "Video Stream Count", "Video Call Count"}), #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each true), #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [Year] = "2021") in #"Filtered Rows1" Error: OLE DB or ODBC error: [Expression.Error] The column 'DataModelName' of the table wasn't found.
Teams CQD Endpoint csv Upload
I am trying to isolate devices in my CQD specifically MTRs and in the documentation it refers to creating an endpoint csv to write custom tags for endpoint information but it doesn't say where to upload the csv file. Does the csv upload to the device folder or to the cqd? https://docs.microsoft.com/en-us/microsoftteams/turning-on-and-using-call-quality-dashboard#endpoint-data-file
How long is QoE CDR data stored in O365?
We were using CQD to analyze call data and I notived that most of the reports only show data from the last 12 month. I cound not find the information how long the QoE/CDR data which CQD shows is stored? I can only find information on the EUII data (28 days). For example if you want to analyze call queue data over years will that be possible? Do i have to export data for each year to achieve this?
CQD - Customised reports no longer able to load visuals
Hello, We have developed Power BI reports using CQD datasets. The visuals have been loading properly most times since its launch last year. However we are currently experiencing errors to load most of the visuals for more than a week now. We have not changed anything prior to that. Error: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). Any idea why? Start Time is also problematic. It does not load.
