Forum Discussion
Advocate IAdjust to local time on report server
So my organization's time zone is EST, but when I uploaded it to report server, the last updated time is an hour behind (it SHOULD say 12:25PM, which is my current time). What's the easiest way to fix this so it reflects correctly in report server, but isn't an hour ahead of the actual time in the desktop file (don't want it to say last updated at 1:25PM in the desktop version)???
3 Replies
hokiefan1113Anonymous Right now that "Last Updated Time" card is from a custom column (GetDate = NOW()) in my dataset. I've read that using the NOW() function will return UTC time, so there has to be another solution that displays the correct time on PBIRS as well as on desktop
Ah okay, you created the date field in powerbi.
Take a look here, this should solve your problem: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328
