Share
Report
11I have been able to link our Dataverse in Power Platform to Microsoft Fabric, which allowed me to access certain email analytical tables in Lakehouse. Tables such as EmailSent, EmailOpened, EmailClicked, etc.
However, I can't seem to find the related tables that would allow me to fetch the details about the email or journey. The ids provided in the columns are either not relevant to what we're looking for, or there are no other external tables we can access that could provide any additional insight.
For example, the EmailSent provides us the following columns:
- CustomerJourneyId
- JourneyRunId
- JourneyActionId
- MessageId
MessageId isn't referencing msdynmkt_email, and neither is CustomerJourneyId to msdynmkt_journey. I do see a table called msdyncrm_customerjourney, however it is empty. In addition, none of the fields reference any tables that I found.
Anyone come across a solution to this?
I have the same question (0)
All responses (
Answers (
