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
Do we have a solution for this now? Im still having trouble with this issue. All the data from my sharepointlist need to plus by 1 in power BI and with a lot of data it can get very confusing
You can create 1 custom table with multiple columns based on platform.
The core columns are:
YEAR (add maybe the next 25 to 50 years starting with current year)
March2ndSunday (start of DST)
November1stSunday (end of DST)
Then you add extra columns you need such as the ones below with an if statement to capture the date if they are in or outside of DST and adjust UTC+(#):
PowerBiService_col
DST_col
Sharepoint_col
Somesite_col
etc...
It's definitely an extra step, but well worth it. Once setup, you already have the years and DST accounted for so you are just adding columns and adjusting the if statement as needed so you just set it and forget it.