Dynamic Text per Refresh

[kirabray]

Hello!

I am building a report with an Excel file that will be updated every hour in a Sharepoint folder and then the Power BI report will have a scheduled refresh to update the report with the new data from the file.

I want to have a text box that says "Data Updated from XX:XX File Refresh" and base the time on the hour each file refreshed. Does anyone know how to get the time of the refresh as a usable field to put in the text box? Thanks in advance!

[halfglassdarkly · Accepted solution]

I think the usual way to do this is to add a column in PowerQuery that calculates the current date/time. see: https://learn.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devop...

Would be nice if there was a built in function in Dax for this!

[kirabray]

Oh perfect, thanks so much!