Dynamics Community Forum Thread Details

Timezone of EmailDelivered table in Customer Insights-Journeys Real-time

I am using the EmailDelivered, EmailOpened, and EmailClicked tables to create a Power BI report to analyze our email interactions. I'd like to know what time zone the "Timestamp" column is using. We are in US Central time zone so I know the chart I have is in a different zone. I'm not sure if all of the rows are in a standard time zone, or if they might be coming from the recipients time zone. Any documentation is appreciated!

Categories:

Dynamics 365 Customer Insights - Journeys

Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today!

The "Timestamp" column in the EmailDelivered, EmailOpened, and EmailClicked tables in Dynamics 365 Customer Insights - Journeys Real-Time is typically stored in Coordinated Universal Time (UTC). This ensures consistency across different regions and time zones. Therefore, the timestamps in your Power BI report are likely in UTC.

To align the data with your local time zone (US Central Time), you can apply a time zone conversion in Power BI. Here's how:

Steps to Convert UTC to US Central Time in Power BI:

Add a Custom Column:
- In Power Query, create a new column to adjust the UTC timestamp to US Central Time.
- Use the formula:
  DateTimeZone.SwitchZone([Timestamp], -6)
  
  (Replace -6 with -5 during Daylight Saving Time.)
Apply the Transformation:
- Ensure the new column reflects the correct local time for your analysis.
Update Visualizations:
- Use the adjusted timestamp column in your Power BI charts and reports.