Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Faithick
Frequent Visitor

Mailchimp connector for destkop TOO SLOW

Hello,


I have been trying to do some analysis on our running Mailchimp campaigns, but the data load to Power BI Destkop takes too long. Already trimmed down the dataset to least possible size, but some tables still take forever to load.

 

Do you have any ides on how I might speed things up? Is it an issue with Power BI or Mailchimp?

 

Thanks,
Martin

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Faithick,

Which tables do you load into Power BI Desktop? How many rows in these tables?Unselect the following options in your PBIX file and check if the issue begins to ease .
1.PNG 

In addition, I would recommend you connect to this Mailchimp PBIT file in the latest version of Power BI Desktop(2.57.5068.501), then check if you 

Regards,
Lydia

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.

Hi Lydia, 

 

I'm experiencing exactly the same thing and I've gone and changed all the setting as per your earlier email.

 

In the Edit queries, I can see the preview of all the tables, but the moment I try to apply it, it keeps error out saying the mailchimp server is unavailable.  When I do apply query changes, it would say loaded "xxx" rows in, but then it goes into an error window.  Any Idea what's happening?

 

Thanks

Jubia

Hi @jubiajae I know this reply is very late lol. Since there’s no built-in connector for Mailchimp to PBI anymore, 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 the other options. I've tried windsor.ai, supermetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) 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:

 

MAILCHIMP-1.jpg

 

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.

 

MAILCHIMP-2.jpg

 

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

 

MAILCHIMP-3.jpg

 

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. 

 

SELECT_DESTINATION_NEW.png

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors