Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
6 years ago

Mailchimp API

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 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    Unicorn_Tech
    Icon for Resolver I rankResolver I
    6 years ago

    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?