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
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