Forum Discussion
Helper IIPowerBi service time zone change
Hi all,
I know this is an on going issue with BI service time defaulting to UTC time zone. I have quite a few measures on my model that relies on time functions like "Today( )", "Today( ) -1", etc. These measures are additional columns in my calandar table to identify today, yesterday, dates in last month.. etc.
Once the model is uploaded on to BI service, all these measures become inaccurate untill mid day (AU time) when UTC time laps over 12 am. We also got daylight savings down here which makes it more difficult...
can anyone suggest a proper solution for this issue.
thanks 🙂
HI Bokchoy ,
This is an ongoing issue for everybody (except I guess those that work at UTC -0 ). There are a number of solutions available though. Here are four such links (depending on your preference):
Conversion UTC to local time date - Microsoft Power BI Community
How to convert UTC into Local Time Zone in Power BI Report using DAX? - PowerBI Talks
Converting UTC to local datetime in Power BI – Cloud BI
Convert UTC to Local Time in Power BI - IntelliTect
1 Reply
- collinq
Super User
HI Bokchoy ,
This is an ongoing issue for everybody (except I guess those that work at UTC -0 ). There are a number of solutions available though. Here are four such links (depending on your preference):
Conversion UTC to local time date - Microsoft Power BI Community
How to convert UTC into Local Time Zone in Power BI Report using DAX? - PowerBI Talks
Converting UTC to local datetime in Power BI – Cloud BI
Convert UTC to Local Time in Power BI - IntelliTect