Forum Discussion

raymondwkmok's avatar
raymondwkmok
Frequent Visitor
4 years ago
Solved

Incorrect Time Zone setting at Power BI Service

Hi there, it’s related to time zone issue. I’ve made the necessary setting at the Power BI Desktop that shows the time correctly in the desktop version at UTC+8:00.   The report at Power BI Service...
Need Help
Burningsuit's avatar
Burningsuit
Resident Rockstar
4 years ago

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

MattRo's avatar
MattRo
Frequent Visitor
3 years ago

Hello Stuart, assuming that I am publishing my report from Desktop to Service, does this mean that I can never have my date/time value displayed correctly in both places? I understand that I can use DAX/PQ make the date/time value accurate on service, but then it is displayed incorrectly when I have it displayed in desktop, right? Thanks!

  • Prajwalkumar's avatar
    Prajwalkumar
    New Member
    2 years ago

    Found a simple Solution, 
    Create New Measaure

    Current UTC Time = UTCNOW()
    it will ALWAYS displays result in UTC you can then modify it 

    Current UTC Time = UTCNOW() + TIME(5, 30, 0)
    it will add + 5 hours 30  min

    If you have already existing dates then you can now do some calculations like +- for your results, use AI like chatgpt or geemini for that help