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.
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.
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.