Documentation Index

Fetch the complete documentation index at: https://learn.workforceexperience.hp.com/llms.txt

Use this file to discover all available pages before exploring further.

MTR Injection from MS Teams CQD using PowerBI

New
  • Updated on Jun 18, 2026
  • Published on Jun 18, 2026
  • 2 minute(s) read
  • s
  • s
 Prev Next

Introduction

When Microsoft Teams Rooms (MTR) device data is available in HP WXP Collaboration, administrators can view device information, call records, quality of service (QoS) details, and meeting room usage.

This article explains how to leverage PowerBI to create a specific CQD Dataset Workspace in the environment that can be integrated with WXP Collaboration.

Note: Please perform the following integration if some of your Microsoft Teams Rooms are NOT part of your Intune environment as having additional PowerBI and CQD Integration will ensure all Microsoft Teams Rooms in your environment are catalogued.

Scope

If the PowerBI and CQD integration is done, WXP Collaboration utilizes PowerBI REST APIs provided by Microsoft to gather Teams Room data.

Scope

Type

Permission

Microsoft Reference

User.Read

Delegated

Allows WXP Collaboration to sign-in to the app and allows the app to read the profile of the signed-in user.

Link

Dataset.Read.All

Delegated

Allows WXP Collaboration to access the list of datasets from the Workspace defined in PowerBI as per the below procedure

Link

Workspace.Read.All

Delegated

Allows WXP Collaboration to access the shared Workspaces data defined in PowerBI as per the below procedure

Link

PowerBI Setup and CQD Integration

This section provides guidance to create and integrate the specified customer CQD dataset in the Microsoft environment by using Power BI. It also describes how to integrate the dataset with the WXP Collaboration Cloud collector for Teams.

  1. PowerBI CQD Dataset Workspace Creation and Integration: This involves creation of a PowerBI workspace for integration with the specfic CQD dataset.

  2. PowerBI CQD Integration with WXP Collaboration: This involves integration of the PowerBI Workspace and dataset into Teams Cloud collector of WXP Collaboration.

Note: You must have Global Administrator role credentials for the PowerBI dataset workspace creation and integration and for authorization

Part 1 : PowerBI CQD Dataset Workspace Creation and Integration

  1. In app.powerbi.com, create a shared workspace. Suggested name: CQD-API.

    • From the URL, note the workspace (group) ID.

    • Ensure the workspace name includes “CQD.”

    Browser screenshot showing app.powerbi.com/groups/... address bar with the workspace (group) ID highlighted; page shows the Power BI workspace titled CQD-API.

  2. Download MicrosoftCallQuality.pqx to your computer.
    MicrosoftCallQuality.pqx        

  3. Install the Power BI Desktop application.

    • Go to [Documents]\Power BI Desktop\Custom Connectors on the computer.

    • Create the folder if it does not exist.

    • Copy the downloaded MicrosoftCallQuality.pqx file into this folder.

    Windows File Explorer showing the Documents\Power BI Desktop\Custom Connectors folder with MicrosoftCallQuality.pqx listed (file name, date modified, type, size).

  4. Open Power BI Desktop and sign in to your Power BI account.

    1. You must be a Global Administrator to complete the next steps.

    2. Use the user profile icon to sign in, sign out, or change the account.

  5. Download cqd-basic.pbix to your computer. Double-click the file to open it in Power BI Desktop. Click OK on the warning message.

    Dialog titled Potential security risk in a dark theme showing a warning that the file uses multiple data sources, explanatory text, a Learn more link, and OK and Cancel buttons

  6. On the File menu, select Options and settings, and then select Data source settings.

    • Select Microsoft Call Quality, and select Edit Permissions.

      Data source settings window screenshot showing Microsoft Call Quality in the list and an Edit Permissions button highlighted

    • Review the Privacy Level. The default value is None. Make a note of the value.

  1. On the Home menu, select Publish.

    Publish to Power BI dialog screenshot showing workspace selection area with CQD-API workspace visible and Select and Cancel buttons

  2. On the publish prompt, select the CQD-API workspace and continue to Publish.

    • Select Save if prompted.

    • Select Replace if a report or dataset already exists. You will get a success notification:

    Power BI publishing success dialog with dark background showing 'Publishing to Power BI', a green check and 'Success!', a link to open the report, and a 'Got it' button

  3. After a successful publish, open the CQD-API workspace in app.powerbi.com.

    • The cqd-basic semantic model displays.

    • Hover over the item name, select the ellipsis (…), and select Settings.

    Power BI CQD-API workspace list view showing workspace header, list of items, and a context menu/ellipsis next to an item

  4. In Data source credentials, select Edit credentials.

    • Ensure the Privacy Level matches the Privacy Level noted earlier.

      Data source credentials panel showing a yellow warning 'Failed to test the connection to your data source. Please retry your credentials.' with 'Edit credentials' highlighted

  5. Select Sign In and use Global Administrator credentials.

    Configure CQD dialog box showing fields extensionDataSourceKind and extensionDataSourcePath, Authentication method dropdown set to OAuth2, Privacy level dropdown set to None, and Sign in and Cancel buttons

  6. A confirmation notification appears on the right top corner. The Failed to test connection message no longer appears in Data source credentials.

Part 2: Power BI CQD Integration with the WXP Collaboration Admin Portal

  1. Go to Admin Portal > Infrastructure > MS Teams Integration.

  2. Open the PowerBI CQD Authorization dropdown, select CLICK TO AUTHORIZE, and enter your credentials. A new page opens.

  3. Return to the MS Teams Integration page.

  4. Confirm that all fields are populated.

    PowerBI CQD Authorization panel showing a CLICK TO AUTHORIZE button, an Authorization Token dotted line, fields for Authorization status, Workspace ID and Dataset ID, and a REMOVE AUTHORIZATION button

  5. Validate that the Workspace ID matches the workspace ID captured earlier when creating the CQD-API workspace.

For any assistance, email us at support@wxp.hp.com.

For FedRAMP-specific support, email us at fedramp-support@wxp.hp.com

Related articles