Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created a custom report using the Mailchimp Connector (not the Content Pack) and published it to the Power BI service. When I try to schedule a refresh, I get this on the schedule page:
You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.
I'm only using 2 data sources for the report - one is data from our SQL server which is already set up in the data gateway and the other is Mailchimp, which I do not see as set up on the data gateway. I was under the impression that using the connector would automatically configure this.
Can anyone give me instructions on what I need to do to add the Mailchimp data source to the gateway?
Thanks very much in advance.
Hi @terrajen Now that mailchimp connector is not available 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 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.
Hi @terrajen,
Since mailchimp connector still in beta, I not recommend you to create report with combine datasource.
If you test with single mailchimp datasource, does gateway work well? Please share more detail contents to help us clarify your situation.
Regards,
Xiaoxin Sheng
The report I created is using mailchimp campaign data to determine orders generated from a campaign. I need our customer, orderheader and orderline tables to be able to do this.
I have not tried testing the report with combined datasources because then it would not be very useful but I will test just to see if it works with just mailchimp dataset. If that is the actual isssue, do you have a suggestion on how I may get around this so I can create a mailchimp report using our company's dataset?
Thanks for you time!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.