Visualizing last refresh date in power bi

Question

Is it possible to add a card in power BI that shows the last time the underneath dataset has been updated?

Many thanks!

Answer 1

• Create a blank query and use the following M query to create a single-cell table:

let

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

in

    Source

• Use the Card visual and drag in the column to show it. You can rename the field to remove the default aggregation.  
• Value gets recalculated each time the data is refreshed.