How to define a refresh date on a dashboard?

[Anonymous]

Hi All,

I have a requirement to show/display the latest refresh date on the dashboard/report.

Example: If 1st refresh is on 9AM  12/01/2020

the next refresh is on 11AM 12/01/2020

                                    1PM 12/01/2020 like this.

If date changes it would automatically need to update

Appriciate your help.

Thanks,

Anand

[hkice · Accepted solution]

Try this - How to show the time data was last refreshed on a Power BI report.
1. Open Power BI Desktop and go into the Query Editor
2. Click on New Source and select Blank Query
3. Rename the Blank Query from Query1 to Last Dataset Refresh
4. Click on the Advanced Editor and put in the following M Code:

let
TodaysDate = DateTime.From(DateTimeZone.FixedLocalNow()+ #duration(0,-4,0,0)),
#"Converted to Table" = #table(1, {{TodaysDate}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last Refresh Date Time"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Last Refresh Date Time", type datetime}})
in
#"Changed Type"

5. Close and Apply

6. Create a Calculated Measure called Data Last Refreshed
Data Last Refreshed = VALUES ( 'Last Dataset Refresh'[Last Refresh Date Time] )

7. Put a Card Visual in the report
8. Drag the calculated measure you just created, Data Last Refreshed, to the Card visual

Done

Hope this helps.