Forum Discussion

TarasHrytsak's avatar
TarasHrytsak
Frequent Visitor
5 years ago

How to get data from Dynamics 365 Marketing Insight?

Hi,

 

I have a problem, I need to visualize information about about delivered email, unique opens, unique clicks and other.

I'm trying to connect from Power Bi Desktop to Dynamics 365, but I don't see this statistics.

How i can get data from marketing insights?

3 Replies

    • TarasHrytsak's avatar
      TarasHrytsak
      Frequent Visitor

      Hi Anonymous ,

      Unfortunately i'm use Dynamics 365 crm , i'm don't use Dynamics 365 Customer Insights

       

      Thank you,

      Best Regards,

      Taras

  • Hi,

     

    I've just looked into this today - from this Microsoft explainer:
    "Interaction data is stored in the marketing-insights service database and includes information about how your contacts interacted with your marketing initiatives, including email opens, email clicks, event registrations, page submissions, and more. You can see this type of information when you look at the insights built into Dynamics 365 Marketing, but you can't create these records nor view them directly. In the current release, you'll use the Power BI "Azure Blob Storage" connector for this type of data. In future releases, you'll also be able use the dataflow connector.

    You'll be able to connect directly to your Dynamics 365 Marketing database from Power BI to fetch your profile data, but to access interaction data you'll need to set up Azure Blob Storage, configure Dynamics 365 Marketing to save interaction data there, and then connect Power BI to your blob storage"

    Prepare for analytic reporting with Power BI (Dynamics 365 Marketing) | Microsoft Docs