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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mattiarusso
Frequent Visitor

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 field is the same in the CRM, but when i pubblished the report in Power BI Service, the API REST convert my date/time field in UTC time zone. I tried to convert the date in power query by using the function DateTimeZone.ToLocal([my date/time field] but the function convert my date in the UTC time zone,I think because the data is stored in Ireland (GMT Time, UTC +0) and I want to display data/time field in CET time zone (UTC +1) .
Someone could help me?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thank you @v-shex-msft.

 

What will happen when the time zone will change by CET (Central Europe Time [UTC +1])  to CEST (Central Europe Summer Time [UTC +2]). The function DateTimeZone.SwitchZone handles this datetime zone change?

 

 

Thanks again

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

@v-shex-msft / 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

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.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors