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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors