Report Last Refreshed Date and Time

[MarioCadena]

Hi,

I added the last refresh date of the report using the following formula in power query.

= DateTime.LocalNow()

In Power BI Desktop works well

But in power Bi Services format and time are not right; I tried on Chrome and Explorer the same result.

Do you have any recommendations?

Regards,

Mario

[v-henryk-mstf · Accepted solution]

Don'@MarioCadena,

This is not directly related to which browser it opens. Depending on your description, the first thing you need to understand is that this formula returns a DateTime value set to the current date and time in the system. So on the desktop it returns the system time, but in the service, PowerBI will follow the current position of the server, it will return to the last update time. I tried to use the UTCNOW() function and got the same time both on the desktop and in the service. You'd better learn about this feature.

This is a related blog and a similar post, it can be used as a reference.

Solve the DAX time zone problem in Power BI - RADACAD
Fixed: Last Time Update - Microsoft Power BI Community

If the problem is not yet resolved, provide detailed information about the error and let me know immediately, waiting for your response.

Best regards
Henry

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Singaravelu_R]

Hi,

Please try below measure

Date &Time = UTCNOW()