Forum Discussion
alpinzar
6 years agoMicrosoft Employee
Auto Refresh timestamp as label in report
Hi guys, I have a report which is auto refreshed every 3 hours and I don't see any options to show this on the report itself. How would one implement a simple label like "updated on 4/16/2020 4:0...
- 6 years ago
Perhaps create a column in one of your tables that is simply:
Column = NOW()
This should get recalculated as part of refresh. Then just add this to a Card visual using MAX aggregation.
alpinzar
6 years agoMicrosoft Employee
so if refresh fails the column will not be populated as well, keeping prev date?
v-easonf-msft
6 years agoCommunity Support
Hi , alpinzar
Only when your data is successfully refreshed, the new refresh time will be displayed, otherwise it will be the original old data
In addition ,you also can start in Power BI desktop with “Get data”, “Blank Query”. Here I enter
= DateTime.LocalNow()
If help ,refer this post.
You can also refer to some related post and video from 3rd party Links:
Best Regards,
Community Support Team _ Eason