cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
601
Views
1
Helpful
2
Replies

Power BI API Connection

JayAustin
Level 1
Level 1

Has anybody tried connecting Power BI directly to the data in the WxCC Analyzer using an API? I keep running into issues and I just want to see if anyone has any thoughts before I abandon the idea entirely.

I currently export the data into csv files and manually import them into Power BI because I have a lot of calculations I perform that are too complicated to work into the current WxCC user interface. I'd love to bypass the manual step entirely if possible so the data can be handled by people other than myself.

 

2 Replies 2

cdrguru
Level 1
Level 1
@JayAustin

Yes, you can connect Power BI directly to the WxCC APIs, but as you're discovering, it requires significant development work. You have to handle authentication, API rate limiting, pagination, and then transform the raw data into a usable model before you can even start writing DAX.

There is a much simpler path. We built Expo XT for Webex Contact Center, which is a pre-built Power BI application available on the Webex App Hub.

It’s designed to solve this exact problem by providing a ready-to-use solution that includes the complete data pipeline and a robust semantic model. It comes with all the key fact tables and measures you'd need, like abandonment rates, agent performance, and queue analytics. As the screenshot shows, measures even include natural language descriptions powered by AI, so your team can understand the logic without having to be DAX experts.

Instead of spending weeks building a custom connector, you can have comprehensive WxCC analytics running in Power BI within minutes.

You can find it on the Webex App Hub here: Expo XT WxCC Analytics in Power BI - Webex Apphub

webexcc_semanticmodel.png

If you're interested in skipping the development headache, I'm happy to schedule a quick 15-minute discovery call to see if it's a good fit.
-CDRGURU

Rudrakshi
Cisco Employee
Cisco Employee

Hi @JayAustin , You can integrate WxCC with Microsoft Power BI https://github.com/WebexSamples/webex-contact-center-api-samples/tree/main/reporting-samples/graphql-powerbi-sample , if that's what you're looking for.



Best regards,
Rudrakshi Srivastava