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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
EstherxIrene
Regular Visitor

Mailchimp app empty fields

Hey guys,

 

I'm kinda new to this community and am not a pro in Power Bi either, but thanks in advance for taking effort in reading my question!

 

So for a while I've been using the Mailchimp connector in Power Bi Desktop tool, worked fine and I was very content with it. Just a while ago the Mailchimp connector has been removed from the desktop 'Get Data' data sources. But it appearantly is available as an app for the Power Bi web client/service (see https://appsource.microsoft.com/nl-nl/product/power-bi/pbi-contentpacks.pbiapps-mailchimp?tab=Review...

 

I'm able to download it and connect our MailChimp account. But the visuals stay empty. 'Leeg' is Dutch for 'Empty' 🙂 

Mailchimp Power Bi empty.jpg

 

 

 

Has anyone used this app and maybe knows if there is a way to fix it or maybe knows another way to visualize MailChimp data?

Extracting data from MailChimp and importing it in power bi manually is not doable, since we send at least 2 or more e-mails per week.

 

Thanks for thinking with me 🙂

 

KR,

Esther

4 REPLIES 4
CoderZen08
Helper III
Helper III

Hi @EstherxIrene Since the Mailchimp service pack was deprecated, you would 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:

 

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

mariafialhoHXL
New Member

Hi @EstherxIrene ,

 

I'm facing the same problem as you and Mailchimp source disappeared from the desktop 'Get Data' data sources.

 

Are you still without the Mailchimp source on your desktop?

 

Thank you,

Maria

v-jayw-msft
Community Support
Community Support

Hi @EstherxIrene ,

 

Haven't used Mailchimp yet but I think these blank visuals should be filled with data value. Are you sure you have done this?

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Hi Jay,

 

thanks for your reply! Data value have been inserted.. It's a predesigned dashboard so it should fill automatically, but i'm afraid the connector isn't working well 😞

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.