Get Email Click and Open stat data for Power BI without having to get Premium Capacity in BI

(1) Share

Report

Posted on by MikeC282

2,142

I've been reviewing how to get Customer insights journey data like email opens, clicks and sends for custom Power BI reports but the only article for it requires a Premium Capacity workspace which is just downright robbery.

https://learn.microsoft.com/en-gb/dynamics365/customer-insights/journeys/fabric-integration

Is there anyway to get this data into Power BI without having to use premium capacity? I can see Outbound Marketing seems to have a way but we are using journeys.

I can't see what tables actually store this data in the Dataverse. I assume all this data because it's so heavy in terms of how much data it must load that it's not actually stored in the Dataverse but somewhere else? Is there any way for me to access it?

All responses (1)

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Get Email Click and Open stat data for Power BI without having to get Premium Capacity in BI

Hi,

According to the blog.

Custom Reporting in Dynamics Marketing

Interaction data for real-time marketing is stored in a managed data lake.

And, according to this blog.

Extracting Marketing Interactions in Dynamics 365 Marketing - Microsoft Dynamics Blog (archive.org)

This blog provides methods for extracting marketing interaction data from a managed data lake.

Best Regards,
Dengliang Li