Last time Refreshed

[cristianml]

Hi,

I need a DAX formula or measure to share last time I refreshed the information inside my model or in a tab in APPs.

Any suggestions ?

Thanks, 

[cristianml · Accepted solution]

Hi @v-yuta-msft ,

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

Thanks

[v-yuta-msft]

@cristianml ,

I'm afraid currently there's no dax formula which can catch last refresh date in power bi service. You can only configure schedule refresh interval in power bi service.

Regards,

Jimmy Tao

[cristianml · Accepted solution]

Hi @v-yuta-msft ,

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

Thanks

[domingom]

Awesome. Thank you for sharing.

[ntaylo06 · Accepted solution]

Here is what I use for my dashboards. The date does not work in PBI desktop, but shows up in app.powerbi.com

In PBI DesktopIn app.,powerbi.com

Minutes Since Last Refresh = 
VAR hours = DATEDIFF(MAX('Date Tracker'[Last Refresh]), UTCNOW(), HOUR) - 1
VAR minutes = DATEDIFF(MAX('Date Tracker'[Last Refresh]), UTCNOW(), MINUTE) - IF(hours > 0, hours * 60, 0)
RETURN "Time since last refresh: " & IF(hours <= 0, "", hours & IF(hours = 1, " hour ", " hours ") & "& ") & minutes & IF(minutes = 1, " minute", " minutes")

Let me know if you have questions

[domingom]

Hi @cristianml . I do not know of any DAX formula or measure that allows you to display when a dataset in the PowerBI Service has last been refreshed. I know that it is possible to retrieve dataset refresh history using a Power BI REST web api call. Hope this helps.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory

[cristianml]

hi @domingom ,

Thanks but I need a DAX formula to use it with a visual in the model so END USERS can see last time updated.

Regards.