Refresh Time on Server

[Anonymous]

Hi, I have a question regarding the refresh time on my Power BI reports.

This is what I currently have on my report to identity the data refresh date and time. Last Refresh on = "Data Last Refreshed: " & Format(FIRSTDATE('Last Refresh Date'[Last Refresh Date]), "m/dd/yyyy h:mm AM/PM").

It works perfectly as doing data fresh on my location machine; however, once I upload the report onto the server, the time stamp does not respond to what it should be. Thank you in advance for the supports!

This is what I see on the server, the data refresh that gateway sets up is @ 7am daily. 

After the data refresh, the time stamps stays @ 12:10pm. 

Thank you in advance for the supports!

[Anonymous]

HI @Anonymous ,

AFAIK, power bi service will convert datetime to utc format, it not support to display as your location datetime.

BTW, your formula will get the first datetime form 'last refresh date' table, it not really get the refresh date time from gateway.

Regards,

Xiaoxin Sheng