Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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:
Regards,
Xiaoxin Sheng
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:
Regards,
Xiaoxin Sheng
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
@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:
= 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