Forum Discussion
Can't schedule data refresh on Mailchimp report using Mailchimp connector
Hi terrajen,
How did you configure datasource of mailchimp? Which type gateway you used? Please share more detail informations to help us clarity your issue.
Regards,
Xiaoxin Sheng
The issue is that I can't configure the datasource for Mailchimp when I use the Mailchimp Connector. The connector uses OAuth2 authorization and the gateway configuration does not include that as an otion.
The comment above mentioned that because mailchimp connector is in beta, I should not combine datasources. I tested a report only using mailchimp connector and did not include my SQL server data sources and the gateway configuration had an automatic configuration for mailchimp and I'm able to schedule a refresh.
However, this is useless to me as the report Im creating is to determine orders generated from mailchimp campaigns, so I need to combine datasources and add our order tables and customer tables in ordder for this report to be valuable. So, I need to use mailchimp connector and also our tables from our SQL server.
Is there a way to grab mailchimp data without using mailchimp connector? Can I access the tables I need using a web source wth an api key authorization?
These are the tables I'm using.
HI terrajen,
Based on my research, I found mailchimp is a online data source which not need to use gateway.(power bi will use connection directly mode to refresh)
If power bi still alert you to use gateway to handling these dataset, it mean you report both contains on-premise datasource and online source.
AFAK, current on-premise gateway can't manage merged datasource, please use personal gateway to handling these combined datasource.
Please share screenshots about data source credential to help use clarify your scenario.
Regards,
Xiaoxin Sheng