Search code examples
data-visualizationpowerbidaxm

Visualizing last refresh date in power bi

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

Many thanks!

Solution

  • You can 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

    query

    And then you can use the Card visual and drag in the column to show it. You can rename the field to remove the default aggregation. (It doesn't matter since there is only one row of data anyways)

    result

    The value will be recalculated each time the data is refreshed.