cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BPhetchamphone Regular Visitor
Regular Visitor

UTC CRM Timestamp Issues with Q&A

I am currently getting data from CRM Dynamics using an OData connection. Everything is great with the exception of one unfortunate issue ; the UTC timestamp. All of the data in CRM Dynamics is stored in UTC, and though you may be able to format the data to local time in power bi desktop, whenever you use Q&A on this dataset (i.e. "total sales today") the "Today" is also in UTC time. This renders Q&A completely useles for anything that is time-based. Has anyone found a solution to this? How do you deal with the UTC timestamp in CRM ? 

6 REPLIES 6
Super User
Super User

Re: UTC CRM Timestamp Issues with Q&A

If you are using Power BI Desktop (PBIX files) you should be able to create a calculated column in your Power BI model that performs a date-offset from the UTC column which you can then use in Q & A


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

BPhetchamphone Regular Visitor
Regular Visitor

Re: UTC CRM Timestamp Issues with Q&A

@Phil_Seamark. This works for the most part, however, around 5pm MST the card for  "Sales Today" goes blank. It repopulates the next morning with proper data, but as soon as it's midnight UTC the card becomes blank. Any thoughts on workarounds ? 

Super User
Super User

Re: UTC CRM Timestamp Issues with Q&A

Sounds like an issue with your formula.  What timezone are you in?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

BPhetchamphone Regular Visitor
Regular Visitor

Re: UTC CRM Timestamp Issues with Q&A

@Phil_Seamark I'm in Mountain Time. I'm subtracting 7 hours from the UTC timestamp. 

Highlighted
BPhetchamphone Regular Visitor
Regular Visitor

Re: UTC CRM Timestamp Issues with Q&A

@Phil_Seamark I'm in Mountain Time. I'm subtracting 7 hours from the UTC timestamp. 

Surendra_thota Regular Visitor
Regular Visitor

Re: UTC CRM Timestamp Issues with Q&A

How to handle Daylight saving Hour difference