Adjust to local time on report server

[hokiefan1113]

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

[Anonymous]

What Datasource do you are using?

It is possible to use a date from the datasource if the source stayes in the same timezone to the report server

[hokiefan1113]

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

[Anonymous]

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