Visualizing last refresh date in power bi

Question 1

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

Many thanks!

Question 2

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.

If you are preparing for the Power BI certification exam, then take up this Power BI Course online by Intellipaat that offers instructor-led training, hands-on projects, and certification.

Ashok · Answer 1 · 2019-07-10T06:23:00+0000

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.

If you are preparing for the Power BI certification exam, then take up this Power BI Course online by Intellipaat that offers instructor-led training, hands-on projects, and certification.

Visualizing last refresh date in power bi

1 Answer

Related questions

Browse Categories