Supermetrics for Power BI
Connect Omnisend to Power BI — E-commerce Messaging Dashboards
Track Omnisend email and SMS campaigns in Power BI with deliverability monitoring, segment comparison, and revenue attribution analysis. DAX measures calculate revenue per recipient, list health indicators, and campaign ROI across email, SMS, and push notification channels.
Why Connect Omnisend to Power BI?
Build live Omnisend dashboards in Power BI that update automatically and share with your team.
- Track campaign performance with e-commerce-specific metrics. DAX measures calculate revenue per email, conversion rate by campaign type, and list health indicators for DTC brands.
- Monitor bounce rates, complaint rates, and delivery rates with conditional formatting that flags deteriorating sender reputation before it impacts inbox placement.
- Compare email campaign performance across customer segments. DAX measures calculate engagement and revenue per segment, identifying your most responsive audience groups.
How to Connect Omnisend to Power BI
Three steps. Under two minutes. Zero code.
- 1
Open Power BI Desktop and Get Data
Launch Power BI Desktop, click "Get Data," and search for the Supermetrics connector to install it.
- 2
Authorize your data source
Sign in with your Supermetrics account and authorize your data source. Your credentials are encrypted and securely stored.
- 3
Build Your Dashboard
Select your metrics and dimensions, load the data into your model, and start building visuals, DAX measures, and interactive reports.
Dashboard Templates for Omnisend in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
Omnisend E-commerce Email Report
Campaign performance with revenue per email and conversion metrics. Deliverability health monitoring with segment-level engagement comparison.
List Health & Segment Performance
Subscriber engagement scoring by segment with deliverability trending. Campaign type comparison (broadcast, automation) with conditional formatting alerts.
Reporting Scenarios for Omnisend in Power BI
Common reporting use cases that teams build with Omnisend data in Power BI.
Line chart
Revenue per Email Trend by Campaign Type
Line chart comparing revenue per email sent for broadcast campaigns vs. automations over time, showing which approach generates more per-message value.
Scatter chart
Segment Engagement vs. Revenue
Scatter chart plotting segment engagement rate against revenue per recipient, identifying which subscriber segments deliver the most commercial value.
What Omnisend Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full Omnisend reporting data — metrics and dimensions you already know from the Omnisend interface.
Key Metrics
- Sends
- Opens
- Open rate
- Clicks
- Click rate
- Bounces
- Bounce rate
- Complaints
- Complaint rate
- Unsubscribes
- Unsubscribe rate
- Number of campaigns
Key Dimensions
- Campaign name
- Subject
- Sender name
- Campaign type
- Status
- Segments
- Start date
- Creation date
Resources & Guides
14 Power BI marketing dashboard examples
Power BI for marketing: setup guide
Data transformation in Power BI
Browse all Power BI templates
Feld Entertainment: enterprise dashboards
Why Supermetrics for Power BI?
The trusted marketing data platform since 2009. 200,000+ companies use Supermetrics — 15% of global ad spend flows through our connectors.
Built for Power BI
Purpose-built Power BI connector with setup in minutes. Your marketing team can build dashboards independently — no data engineering resources required.
170+ Data Sources
Connect Omnisend alongside 170+ other platforms through a single integration. All your marketing data in one place.
Data Blending
Combine Omnisend with other data sources in Power BI. Blend on shared keys like date, campaign name, or UTM parameters for cross-channel visibility.
Enterprise-Grade Security
SOC 2 Type II certified. GDPR and CCPA compliant. OAuth authentication with encrypted credentials. Regional data hosting available.
Always Current
Your Omnisend data refreshes automatically in Power BI. No manual exports, no stale numbers — open your report and the data is current.
Complete Data Access
Pull every contact, deal, campaign, and custom property from Omnisend. No field restrictions, no record limits — your complete dataset, ready for analysis.
Frequently Asked Questions
- Install the Supermetrics connector from the Power BI Desktop "Get Data" menu, sign in with your Supermetrics account, and authorize Omnisend. Your data appears as a Power Query table — from there you load it into your model, build relationships, and start creating visuals. No custom connector development needed.
- Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your Omnisend data on the schedule you set — hourly, daily, or whatever cadence fits your reporting rhythm. Your dashboards stay current without manual intervention.
- Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull Omnisend alongside data from 170+ other marketing platforms — Google Ads, LinkedIn Ads, GA4, and more — then join them through shared dimensions like date, campaign name, or UTM parameters in Power Query or the data model.
- All standard Omnisend reporting fields are available, including Sends, Opens, Open rate, Clicks, Click rate, and more. You get the same data as the Omnisend native reporting UI, loaded into Power BI where you can create DAX measures, build relationships, and apply row-level security.
- Basic Power BI Desktop knowledge is enough. Supermetrics handles the API connection, authentication, and data formatting. You pick your metrics, choose a date range, and load — the data arrives as clean tables ready for modeling. No API code, no ETL scripting.
- Pull campaign data with order and revenue metrics. DAX measures calculate revenue per email sent and revenue per click. Trend these over time to see whether your email program is generating more revenue per send.
- Yes. Track bounce rate, complaint rate, and delivery rate trends. Conditional formatting flags when rates cross ISP thresholds that could trigger spam folder placement.
Also Connect to Power BI
Ready to Connect Omnisend to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.