Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.