web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Email stats in Microso...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Email stats in Microsoft Fabric and PowerBI

(1) ShareShare
ReportReport
Posted on by TimCoysh 12
I've done the hard work and got Microsoft Fabric into Power BI with all my customer insights data.
 
However I can't work out how to relate tables like EmailSent to msdynmkt_email.
 
All I want is a table of all emails along with how many sents, opens etc it has.
 
Thanks in advance for any help.
Categories:
Dynamics 365 general
I have the same question (0)
  • Suggested answer
    Muhammad Shahzad Shafique Profile Picture
    Muhammad Shahzad Sh... 2,373 Most Valuable Professional on at
    Relationship
    • EmailSent, EmailOpened, etc., contain a foreign key:
      → OutboundMessageId or msdynmkt_emailid (depending on schema origin/version).
    • msdynmkt_email (Email table):
      → Primary key: msdynmkt_emailid
    Steps to Get the Metrics:
    1. Create relationships in Power BI Model view: 
      EmailSent[OutboundMessageId] → msdynmkt_email[msdynmkt_emailid]
EmailOpened[OutboundMessageId] → msdynmkt_email[msdynmkt_emailid]
(same for Clicked, Bounced, etc.)
      2. Create a summary table (DAX example):
        
      EmailStats = 
ADDCOLUMNS (
    msdynmkt_email,
    "Sents", CALCULATE(COUNTROWS(EmailSent)),
    "Opens", CALCULATE(COUNTROWS(EmailOpened)),
    "Clicks", CALCULATE(COUNTROWS(EmailClicked))
)
      3. Visualize in Power BI:
      • Use a matrix or table visual with columns from msdynmkt_email and measures from interaction tables.

       

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
iampranjal Profile Picture

iampranjal 67

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 37 Super User 2025 Season 2

#3
Pallavi Phade Profile Picture

Pallavi Phade 24

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans