Forum Discussion
Set local time zone Power BI Service
On Power BI Service, the now() function will return the UTC time. We can't set the time zone on Power BI Service. To get the correct local time, we can add time different in your DAX formula, or use Power Query to get the local time zone datetime. For more details, please see: Solving DAX Time Zone Issue in Power BI.
Regards,
Thanks v-sihou-msft
The website appears to be down at this time. http://radacad.com/solving-dax-time-zone-issue-in-power-bi. i am wondering if you have an alternative website?
I had researched a little further but no one seems to be able to provide a clear resolution for this yet, including this one: http://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328
Thanks;
Andrew
Try this for ideas: https://community.powerbi.com/t5/Desktop/UTC-to-AEST/m-p/188878#M83075
I agree though, for something so simple as being able to specify a 'local' timezone (such as in your user profile) I'm surprised this is such a difficult task...
-Greg.
