Refresh visuals when report opens in powerbi.com

[U156531]

When I open my PBIX in PowerBI.com my Last Refreshed date field is not displaying the most recent date. I have to click on the Refresh visuals icon in order to get the date to be refrshed. Is there a way to get around this issue. The user should see the latest date so that they know when the report has been last refreshed.

Here is the metthod I'm using to get the Last Refreshed date in the report.

[rajendraongole1 · Accepted solution]

Hi @U156531 -You can create a measure that dynamically captures the last refresh time.

Last Refreshed = NOW()

or 

if you prefer to display the time in UTC

Last Refreshed = UTCNOW()

This will work in Power BI Desktop but will refresh only when the dataset itself is refreshed on Power BI Service. The limitation here is that the date won't update unless a data refresh occurs if you want to get the latest date in pbi services with the help of using tools like Power Automate it works.

Hope it helps.