Difference DateTime between Desktop and Service

[Vincent112358]

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

[v-sihou-msft · Accepted solution]

@Vincent112358

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,

[Vincent112358]

@v-sihou-msft

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.