Last time refreshed one hour behind

[Anonymous]

Hi Guys,

I am using the following to show the last time the report was refreshed.  All works fine in Desktop but its an hour behind when published.  Is there a way to just add an hour to the below code:

= #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})

[v-juanli-msft · Accepted solution]

Hi @Anonymous

There is time difference between Power BI Desktop and Service, it seems you are in the time zone, which is currently UTC+1.

Follow this blog to display the (Correct) Last Refreshed Date with Power BI with the help of an API.

Best Regards

Maggie