Forum Discussion

unclejemima's avatar
unclejemima
Icon for Post Patron rankPost Patron
9 years ago

Subscription sent at wrong time but timezone correct

I've got a scheduled refresh thats set to update data everynight at 10pm MST...but I got the reports sent to me a 6:00pm last night.   I have the scheduled refresh set at 10pm MST...so I'm not sure...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

unclejemima,

 

When viewing reports in Power BI I'm using NOW() function.  This displays my local timezone (MST) in the desktop application. When I'm in the Web Service it will display the timezones as UTC.

Currently, it's default behavior in current version of Power BI. So in your report, you'd better add two time, one is for local time, and another one is for UTC time.

 

Regards,

Charlie Liao

unclejemima's avatar
unclejemima
Icon for Post Patron rankPost Patron
9 years ago

Yes, but in the desktop version if I use NOW() it will display MST...then I rig a NOW+6 it will display UTC...then when I upload it the web version will show NOW() as UTC and the NOW+6 will show some other timezone what +12 from MST...

 

MST is -6 from UTC.

 

So.  I almost need 3 times on my report and depending on where it came from will still have one of them wrong.

 

I guess more importantly, what does the report running in Power BI online do with the other times?  Say I have a ODBC connection to a time field...will it change all those times as time +6 to get to UTC...so all the data is still relative.  Or will it increase the NOW time to UTC and leave the others local time zone?

 

Sorry just trying to figure out if this is just cosmetic or if it affects how the report displays if I have data with times in it.


Thanks!