How can I create a custom measure to show the last data refresh in Power BI

[UdhayakumarT]

How can i display the last data refresh timestamp in Power BI report.

[mdaatifraza5556]

Hi @UdhayakumarT 

can you please folow the below steps to get your results?

Open Power Query---> Create a balank query

Use this M-code 

=DateTime.LocalNow() 

You will get this in list fromate 

Now convert this list to table

Result

If this answers your questions, kindly accept it as a solution and give kudos.

[Abhilash_P · Accepted solution]

Hi @UdhayakumarT ,

You can use below M-Query code - It will create a table named (e.g.) Last Refreshed with the current date and time, which updates every time the dataset refreshes in the service

let
Source = #table(type table [Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source

[jaineshp]

Hey @UdhayakumarT,

Yes, you can create such measure (you can find it anywhere online)

But, you will only able to fetch the time when the scemantic model in Power BI Service Started the refresh process, but not when completed.

I.e., you will only get date&time when the scemantic model started the refresh process but not when the refresh completed successfully (in the case of refresh failure, you user will get timestamp and he/she will consider the model is refresh, but actually it's not)

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer

[bhanu_gautam]

@UdhayakumarT , Check this

https://www.youtube.com/watch?v=oN6mOmEruOQ