Mailchimp - Error Loading Campaign Email Activity

[tibs]

Hello,

I was able to connect to our Mailchimp account from BI Desktop and load several smaller tables, such as the Campaign Summary. However, I'm not able to load the Campaign Email Activity table. The pop-up window is telling me that it's loading and is waiting for xx.api.mailchimp.com. This can go on for hours without any result or error message. On the other hand, when I use the content pack on powerbi.com everything works just fine.

Any idea how this could be fixed?

Thank you

[mtmasson]

So, any solution?

[v-yuezhe-msft]

Hi @tibs,

In Power BI Desktop, please go to File -> Options and settings -> Options -> Diagnostics and click "enable tracing", then connect to MailChimp and check the detailed logs in the traces folder. Also please help to post the detailed logs here.

In addition, the MailChimp connector is still under development, I suspect that it may not work as expected when connecting to large tables.

Thanks,
Lydia Zhang

[tibs]

Hi Lydia @v-yuezhe-msft,

Thank you for looking into the issue. I didn't want to post the whole text file due to its size (it's over 1 MB) but basically these three lines are repated in the file. The only difference is the timestamp and the duration.

Thanks again

DataMashup.Trace Information: 24579 : {"Start":"2016-11-25T14:15:36.5901343Z","Action":"Library/Common/RetryPolicy/ExecuteAction","TryCount":"3","RetryAlgorithm":"ExponentialBackoff","ProductVersion":"2.40.4554.421 (PBIDesktop)","ActivityId":"240ba349-48ac-477e-9d9d-e287c6164db3","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5492,"Tid":1,"Duration":"00:00:00.0028046"}

DataMashup.Trace Information: 24579 : {"Start":"2016-11-25T14:15:36.5900977Z","Action":"Engine/IO/Web/Request/GetResponse","RequestMethod":"GET","RequestUri":"https://us6.api.mailchimp.com/3.0/campaigns/?count=100&offset=0","RequestHasContent":"False","Reques... (PBIDesktop)","ActivityId":"240ba349-48ac-477e-9d9d-e287c6164db3","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5492,"Tid":1,"Duration":"00:00:00.0028543"}

DataMashup.Trace Information: 24579 : {"Start":"2016-11-25T14:15:36.6042853Z","Action":"Library/Common/RetryPolicy/TryExecuteAction","Attempt":"1","ProductVersion":"2.40.4554.421 (PBIDesktop)","ActivityId":"240ba349-48ac-477e-9d9d-e287c6164db3","Process":"Microsoft.Mashup.Container.NetFX40","Pid":5492,"Tid":1,"Duration":"00:00:00.0008897"}