Forum Discussion
Dynamic Text per Refresh
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!
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-devops
Would be nice if there was a built in function in Dax for this!
2 Replies
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-devops
Would be nice if there was a built in function in Dax for this!
Oh perfect, thanks so much!
