Connect to SparkPost with Power BI
The Power BI content pack for SparkPost allows you to extract valuable datasets from your SparkPost account all into one insightful dashboard. Using the SparkPost content pack you can visualize your overall email statistics, including domains, campaigns, and engagement by ISP.
Connect to the SparkPost 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 the SparkPost content pack and click Get.
When prompted, provide your SparkPost API key and select Sign In. See details on finding this parameters below.
Your data will start to load, depending on the size of you account this may take some time. After Power BI imports the data, you’ll see the default dashboard, report, and dataset in the left navigation pane, populated with your email statistics for the past 90 days. New items are marked with a yellow asterisk *.
- 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
The SparkPost content pack for Power BI includes information including unique clicks, accepted rates, bounce rates, delayed rates, rejection rates and more.
The content pack uses an API key to connect your SparkPost account to Power BI. You can find your API key in your account under Account > API & SMTP (more details here). We suggest using an API key with permissions for
Message Events: Read-onlyand