Forum Discussion

mattiarusso's avatar
mattiarusso
Icon for Advocate I rankAdvocate I
9 years ago
Solved

CRM API REST date time zone UTC issue

Hello Everybody, I have a problem with the DateTimeZone in Power BI Service. I retrieved a data/time field by CRM Online in Power BI Desktop by using CRM API REST. In Power BI Desktop the data/time...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi mattiarusso,

     

    According to your description, you want to modify the utc timezone to your local timezone, right?

    If this is a case, you can use DateTimeZone.SwitchZone function or DateTime.AddZone function to achieve your requirement.

     

    Reference links:

    DateTimeZone.SwitchZone

    DateTime.AddZone

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi mattiarusso,

 

Sorry for slow response, I think your datetime will transfer like below:

 

UTC:  8:00 +0
CET:  9:00 +1
CEST: 10:00 +2

 

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous / Xiaoxin Sheng

 

Is it planned to provide an implementation by Microsoft for

Power BI service to evaluate the browser time zone settings?

 

Best would be if your new implementation would do:

  1. Get the current time zone setting from the connected browser
  2. Allow (via dedicated datetime methods) filtering and display to use that request specific user time zone

= Users from Asia or Australia see the same reports as those from Europa as those from the USA.
But: Those from Australia with the appropriate Australian time zone, those from Europe ...

 

Example:

The very same record would show 01:40 May 1, 2018 in Australia
But: 17:40 April 30, 2108 in Switzerland

And: 11:40 April 30, 2018 in New York

 

Best regards, David