cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tibs Frequent Visitor
Frequent Visitor

Mailchimp - Error Loading Campaign Email Activity

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

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Mailchimp - Error Loading Campaign Email Activity

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tibs Frequent Visitor
Frequent Visitor

Re: Mailchimp - Error Loading Campaign Email Activity

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"}

mtmasson Frequent Visitor
Frequent Visitor

Re: Mailchimp - Error Loading Campaign Email Activity

So, any solution?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors