Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

MailChimp Content Pack

I am wondering if anyone knows what happened to the integration capabilities Power BI seemed to have with MailChimp in the past? I have found references on both BI and Mailchimp's sites to a content ...
Need Help
  • collinq's avatar
    collinq
    6 years ago

    Hi Anonymous ,

     

    Content Packs were deprecated a while back.  You will have to use Odata or a third party tool to get to the MailChimp database.  There is an ODBC driver that mailchimp provides as well on their site.

     

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

     

     

QueryWhiz's avatar
QueryWhiz
Post Patron
2 years ago

Hi, since the Mailchimp service pack was deprecated, you will have to look for another way. 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.