Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Date and Time Query was refreshed at the presentation level

Is there any way to add a measure into a Power Bi that shows when the data was refreshed at the presentation level? I created a measure like this but it's only showing the current date and time, not when data is refreshing

RefreshDateTime = Now() 

 

Thanks in advance!

Need Help
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Usually, if you are using a DB, there are columns like "Last Update Date" or "Insert Date time" .if you don't know ask your DB, he might help you.

     

    Once you get it take max of date.

     

     

    Thanks

     

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi jch,

     

    So your requirement is creating a measure to represent the last refreshed time in power bi desktop, right? Because DAX is based on columns, so I would recommend you to create a refresh date column in database and then write a SP to write these date logs to the columns once table has been refreshed. Finnally, in power bi, you can use DAX function like MAX(Table[Column]) to achieve the lastest refresh time.

     

    Regards,

    Jimmy Tao