Forum Discussion
Incorrect Time Zone setting at Power BI Service
Hi raymondwkmok
The Power BI service only operates in the UTC time zone, you need to adjust dates & times in DAX or Power Query.
There are lots of resources on this these few may help..
Dynamic time zone conversion using Power BI – The White Pages (unlimitedviz.com)
Power BI Service Time Differences and How to Fix It (linkedin.com)
Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report - RADACAD
Hope this helps
Stuart
I am using Power Apps (back end SQL with datetimeoffset) and embedding a Power Bi Paginated report, which resides on the Power Bi service. Power Apps deals with local time, summer time etc - Why is Power Bi Service in the dark ages/time? Anyway I found a Power Apps formula: TimeZoneOffset(Now()) which gives the mins offset from UTC for the local user. In the UK it deals with British Summer Time and GMT going from -60 (Summer) to 0 in Winter. When you embed a Paginated report it allows you have one text parameter that you can pass to Power Bi. By adding a large number (say 2000, so it is always 4 digits) and converting to text. I have appended this onto my existing parameter and pull it out in the Power Bi report, take 2000 away and then MINUS this to now(), and hey presto the user now sees their local time they ran the report not the UTC time. Hope you can find a way to use this until Power Bi Services gets up to date...
ProfPlat