Power BI refresh timestamp - Convert UTC to local time zone

[gauravnarchal]

How can I show LAST REFRESH timestamp in the local time zone of a PUBLISHED report in Power Bi App?

In Power BI Desktop I can see the date-time is showing in local timezone but when I publish the report in App the timestamp is shown in UTC.

I am currently using the below Query:-

Last Refresh = DateTime.LocalNow()

Any help would be appreciated,

[v-jayw-msft · Accepted solution]

Hi @gauravnarchal ,

You can add time difference manually like below.

Last Refresh = DateTime.LocalNow() + #duration(0,10,0,0)

Best Regards,

Jay

[amitchandak]

@gauravnarchal ,

You need set timezone setting in power bi service

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

last refresh date

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops