Forum Discussion

alpinzar's avatar
alpinzar
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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's avatar
alpinzar
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

so if refresh fails the column will not be populated as well, keeping prev date?

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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:

    link url1

    link url2

     

    Best Regards,
    Community Support Team _ Eason