Connect to MailChimp with Power BI
The Power BI content pack pulls data from your MailChimp account and generates a dashboard, a set of reports and a dataset to allow you to explore your data. Pull in analytics to create MailChimp dashboards and quickly identify trends within your campaigns, reports, and individual subscribers. The data is set to refresh daily ensuring the data you're monitoring is up to date.
Connect to the MailChimp content pack for Power BI.
How to connect
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Select MailChimp > Get.
For Authentication Method, select oAuth2 > Sign In.
When prompted, enter your MailChimp credentials and follow the authentication process.
The first time you connect you will be prompted to allow Power BI read-only access to your account. Select Allow to begin the import process, which can take a few minutes depending on the volume of data in your account.
After Power BI imports the data you will see a new dashboard, report, and dataset in the left navigation pane. This is the default dashboard that Power BI created to display your data. You can modify this dashboard to display your data in any way you want.
- Try asking a question in the Q&A box at the top of the dashboard
- Change the tiles in the dashboard.
- Select a tile to open the underlying report.
- While your dataset will be schedule to refreshed daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now