Exchange.contents power query returns modified date/time stamp

[ktbell]

Hi brains-trust,

Issue: date/time stamp shown in Power BI power-query results reflects modified date/time not sent and received date/time.

I'm connecting to 'Microsoft Exchange Online' source (also tried connecting to 'Microsoft Exchange' source with the same result) to produce reports for particular mailboxes. I've successfully connected to the mailbox, and can produce reports and visuals.

However, the emails within the mailbox have had their Subject line edited to remove the "FW:" and "RE:" text, and I have noticed that the sent and received date/time stamps in Power BI reflect the modified date/time rather than the actual sent/received date and time that is recorded in the message header (and displayed correctly in Outlook).

Has anyone noticed this? Is there any way to force the query to look to the sent/received date and time in the message header?

[Irshad_Khan]

Hi ktbell,

you can get last modified details from Attributes column by expanding and selecting required columns

[Anonymous]

Hi @ktbell ,

Sorry I can't reproduce your problem. Could you please provide the related screen shots of the date information in Outlook and Power BI? Whether the receive date and sent date information for all emails are incorrect?

Best Regards

Rena

[ktbell · Accepted solution]

well... now I feel a bit embarrassed.

It turns out my confusion was due to my Outlook web app timezone being set to GMT, and the date/time stamp in the message header also reflecting the GMT timezone. So no issues with the Power BI query at all.

Power BI - 1

Me (aka numpty) - 0

[Anonymous]

Hi @ktbell ,

Thanks for your reply. It's okay, sometimes we may miss something. Could you please mark this post as Answered? Thank you.

Best Regards

Rena

[amitchandak]

@ktbell , Not excat, but see if this can help

https://community.powerbi.com/t5/Desktop/Datetime-an-email-was-replied-in-Exchange/td-p/553728