Forum Discussion

BPhetchamphone's avatar
BPhetchamphone
Icon for Advocate II rankAdvocate II
10 years ago

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...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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

BPhetchamphone's avatar
BPhetchamphone
Icon for Advocate II rankAdvocate II
10 years ago

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 ? 

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

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

    • BPhetchamphone's avatar
      BPhetchamphone
      Icon for Advocate II rankAdvocate II
      10 years ago

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

    • BPhetchamphone's avatar
      BPhetchamphone
      Icon for Advocate II rankAdvocate II
      10 years ago

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

      • Surendra_thota's avatar
        Surendra_thota
        Icon for Helper II rankHelper II
        9 years ago

        How to handle Daylight saving Hour difference