Forum Discussion
kirabray
3 years agoRegular Visitor
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 ne...
- 3 years ago
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!
halfglassdarkly
Responsive Resident
3 years agoI 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!
- kirabray3 years agoRegular Visitor
Oh perfect, thanks so much!