Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

DYN365 Power BI template numbers differ from CRM

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello everyone

I am a Business Intelligence Analyst set out to report on our Email Marketing campaigns. KPI's such as: Delivered, Opens, Clicks, Unique Opens and so on.

By using the DYN 365 template from Microsoft, I have gotten the data into Power BI. Email marketing report for Dynamics 365 Marketing (Dynamics 365 Marketing) | Microsoft Docs 

I have no limitation on interaction days, meaning that it gathers all of the data.

My problem is that I just can't get the 'correct' number of emails delivered. By correct I mean the number that is stated in CRM on the specific marketing email. It is only wrong by a small margin.

Does anyone know if there is a filter set in dynamics (other than date), that makes me get the wrong number? I can't find any documentation about this.

The marketing emails that I am looking at is in the past and is currently not active, so it can not be the due to not being refreshed.

  • Suggested answer
    Aga M Profile Picture
    Aga M on at
    RE: DYN365 Power BI template numbers differ from CRM

    Hi Emil,

    Good to hear that you managed to resolve the issue.
    If you encounter any discrepancies in the future, please create a support ticket and we'll investigate.

    Best regards,
    Aga

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DYN365 Power BI template numbers differ from CRM

    An update:

    When using the template, the hard bounces and soft bounces came in 2 separate tables. What I had to do was create a calculated column in Power BI that specified whether the id in the delivered email table existed in one of these 'bounces' columns. If it does, then I have to filter it away. Now the numbers seem reflect what is visualized in Dynamics.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DYN365 Power BI template numbers differ from CRM

    Hi again

    This particular email message only ran for three days in december and yes I have cleared the time filter.

    When getting the data it divides the data into tables such as "EmailDelivered" and "EmailSent". As you can see from the this picture, I am only looking at interactionType 'EmailDelivered'. 

    pastedimage1643275248028v1.png

    In order to give a full overview, here is a picture where the green suggests correct and yellow suggests wrong. Emails opened in CRM is 3722 and Delivered is 4382.

    pastedimage1643275599753v2.png

    Is it possible that the marketing department can define objects that is filtered out in the CRM interactions view?

  • Nya Profile Picture
    Nya 29,058 on at
    RE: DYN365 Power BI template numbers differ from CRM

    Hi,

    So you have cleared the time filter in Dynamics, right?

    pastedimage1643254093015v1.png

    Have you checked if the number in Power BI contains the count of the blocked emails or bounced emails?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DYN365 Power BI template numbers differ from CRM

    Hi Nya, thank you for answering.

    That is exactly what I mean yes - the amount of delivered emails in CRM is not equal to amount that I get in Power BI by using the template.

    On this particular email message, I get 4548 emails delivered in Power BI. Screenshot here: Power-BI-Delivered.png

    In CRM for the same message I get this number instead: CRM-Delivered.png

    For other KPIs, such as clicks and hard bounces, the numbers are the same. This particular email is not active anymore and both numbers are filtered before and after the email was active.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DYN365 Power BI template numbers differ from CRM

    This is a test to see if I can answer you. Yesterday I could not.

  • Nya Profile Picture
    Nya 29,058 on at
    RE: DYN365 Power BI template numbers differ from CRM

    Hi,

    Do you mean that the number of emails captured in Power BI is not the same as in Dynamics?

    If yes, would you please provide a screenshot to show the difference?

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans