Integration of Power BI with Webex control hub

mayank-trivedi — Tue, 24 Nov 2020 09:24:58 GMT

Requirement : to integrate Power BI with webex control hub to pull analytics data for organization users.

Below are the two links, I’m trying to access through web in Power BI, however not working for me.

URL1 : https://admin.webex.com/reports/webexMetrics//metrics

URL2 : https://admin.webex.com/reports/cannedReports

From Power BI desktop

Kindly advice if it is possible to do so.

Regards,

Mayank

Re: Integration of Power BI with Webex control hub

David Anstee — Fri, 09 Jul 2021 13:25:01 GMT

I too would like to see this.

Re: Integration of Power BI with Webex control hub

cdrguru — Thu, 15 Feb 2024 05:54:09 GMT

Hello Mayank,

Integrating Power BI with Webex Control Hub to pull analytics data poses unique challenges due to the direct access limitations of Webex Control Hub URLs through Power BI. However, there are alternative approaches to achieve your goal by leveraging third-party tools and services, such as Metropolis's Expo XT, which can facilitate the integration process.

Expo XT, a Metropolis solution, offers a robust platform for integrating Unified Communications (UC) data, including Webex calling data, into Business Intelligence tools like Microsoft Power BI. It utilizes the Webex Calling Call Log API to query calls in near real-time, providing a comprehensive analytics solution that bridges the gap between Webex Control Hub data and Power BI analytics capabilities.

API Request: The endpoint used is https://analytics.webexapis.com/v1/cdr_feed, with GET method parameters including startTime and endTime for the desired time range and offset for pagination.

For accessing Control Hub data, as you and David Anstee mentioned, leveraging Power Automate to ingest a scheduled email or using the Control Hub download report function within the API could be a viable solution. This method allows for the automation of data extraction and importation into Power BI, enabling the analysis of Webex analytics data alongside other organizational data for a holistic view.

While direct integration might present challenges, the combination of Metropolis's third-party solutions like Expo XT and creative use of Power Automate represents a feasible pathway to integrate Webex Control Hub analytics into Power BI. These solutions offer the flexibility to overcome integration hurdles, ensuring you can achieve comprehensive analytics insights for your organization.

I hope this provides clarity and assists in your integration efforts. Should you have any further questions or require additional guidance, feel free to reach out.

Best regards,
@cdrguru Metropolis Corp

topic Re: Integration of Power BI with Webex control hub in Webex Meetings and Webex App

Integration of Power BI with Webex control hub

Re: Integration of Power BI with Webex control hub

Re: Integration of Power BI with Webex control hub