Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BPhetchamphone
Advocate I
Advocate I

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
Phil_Seamark
Employee
Employee

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!

@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 ? 

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!

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

How to handle Daylight saving Hour difference

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors