Mailchimp API

[Unicorn_Tech]

I need some assistance, I'm quite frustrated.  Calls to PowerBI have basically said "Go to Mailchimp."  Emails to Mailchimp have said "Go to Power BI."

As many of you know, there is no longer the easy connecter between Mailchimp and PowerBI.  You need to use an API.

I have managed to pull data from the following tables:

• campaigns
• lists
• reporting
• campaign folders

Problem 1:  The campaigns table is limited to 120 rows for some reason and won't increase.  It is only including about 8 campaigns, for a three year period (we send out campaigns each week), duplicating the rows up to 120.

Problem 2: I have no idea how to pull member information (like email address), so I can cross reference it with my CRM.  There is no seperate table for "Audience", and Lists doesn't seem to expand.

Mailchimp tells me to go here: https://mailchimp.com/developer/api/

I think that's been exhausted.

PowerBI is telling me this is a problem with mailchimp.  Mailchimp says this is a problem with PowerBI.

[Tomhayw]

Hi there.

I know this is an old post but wondered whether you ever found a solution for who opened each campaign?

I am trying to create a database where each row is an open.

Thanks,

Tom

[ReportGuru]

Hi @Unicorn_Tech  As a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Mailchimp connector in the data sources list:

After that, you will have to first create a secret API key in your Mailchimp account and then using your credentials add your account to the platform.

Once you’ve done this, you can proceed and go to the “Preview and destination” step

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[Anonymous]

Hi, I know Mailchimp is cheaper but maybe you should look into other options to avoid such issues. I suggest you look into Touchdown for D365 & PowerApps. Here's their website for more info if you like https://www.touchdown.co/

[stefannyza]

Good

I have the same problem with mailchimp, the worst thing is that the process of loading reports is slow by the mailchimp theme
There will be some way that you can really integrate better with Power BI.

Since updates are delayed by this API and are dropped.

Best regards

[Greg_Deckler]

@Unicorn_Tech - Yeah, there must have been some kind of falling out between Mail Chimp and Microsoft. But, technically the onus is on the third-party to create a connector to Power BI generally although Microsoft does create them if they are in high demand. Would be nice if everyone could get along but many software vendors want to hang on to your data and force you into their reporting system for $$$$$$.

You can use Power Query to access the API, @ImkeF and @edhans might be able to help.

[Unicorn_Tech]

I've opened a ticket to Microsoft regarding the limitation of the API that I am using (only bringing in 120 records.)  I am not sure if there is a natural limit of APIs, or if this is a PowerBI bug..  Microsoft suggested turning off automatic date and time in the options, to see if that helped - which it did not.

I've reached out to a company called skyvia, which has a mailchimp odata connector service - which will hopefully work in the odata feed of PowerBI.  I'm just surpised how much like pulling teeth this whole process is.  The API connects sucessfully, but only pulls a limited amount of records?

[amitchandak]

@Unicorn_Tech , Not very clear.

Check, the first reply here

https://community.powerbi.com/t5/Developer/Call-a-REST-API-multiple-times-using-Power-Query/td-p/171...

Or how incremental configured for web API

https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/