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,175

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?

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No