Connecting comScore MyMetrix to Power BI

[Eiduo990]

Hi there,

I am trying to connect comScore MyMetrix to Power BI to visualise comScore data (Cross Visiting etc.) in a clean way. I have access to the comScore Web API, and have tried to connect via "Get Data -> Services -> comScore Digital Analytix". However, according to the link below:

"A comScore DAx user account and access to the comScore DAx API is required to connect."

https://docs.microsoft.com/en-us/power-bi/service-connect-to-connect-to

Is comScore DAx different to comScore MyMetrix? Regardless of this, any insight into connecting comScore data to Power BI would be most helpful. (Understanding SOAP Request and Response and doing this in Power BI etc.)

[v-yuezhe-msft]

@Eiduo990,

Are you able to find required comScore parameters in your environment following the guide in this article? 

Based on my research, comScore MyMetrix is different to comScore  DAX, as per this blog, the comScore MyMetrix API can be accessed by any framework that supports connecting to SOAP-based web services. However, in Power BI Desktop, it is a little difficult to connect to SOAP-based web services, you can create an XML file for the SOAP web service and use XML.Tables() function to get data, for more details, please review this similar thread.

Regards,
Lydia