Forum Discussion
Difference DateTime between Desktop and Service
Hi All,
I have a bug with a rapport in Power BI. When I use Power Desktop, the date is in local settings (French). But when I publish my dsahboard on Service, the Date is in UTC.
I try two option for the type of the field Start (Date/Time and Date/Time/TimeZone). But the both is KO
Thanks in advance for your answer,
Best Regards
For Date column, it will always show UTC time on Power BI Service, you can create a custom column and use DataTimeZone functions to set time zone. For more details, please refer to articles below:
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Regards,
2 Replies
For Date column, it will always show UTC time on Power BI Service, you can create a custom column and use DataTimeZone functions to set time zone. For more details, please refer to articles below:
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Regards,
Thanks for your answer. I have always saw this tips but in French, we are in UTC+1 in winter but in UTC+2 in summer.
So, I can not just add one (or two) hour.
I find a solution by using a calendar table. In this table, I add a field who give the numbers of hours to add depending on the date.
