Report dataset ending refreshing time PowerBI

[qsong]

Hi Community

I am wondering if we can report the ending refreshing time in the powerBI report. I checked the forum and it has some useful tips to add last refreshing time (starting refreshing time) in the report. However, I need my clients to know if the report is refreshed, so the ending dataset refreshing time provides more info for my case.

Thank you for any comments

Best, Qianru

[mahoneypat]

I would just use the DAX table with {NOW()} instead as it will calculate after your queries I believe.  But here is one way to add it into your M.

let
TodaysDate = DateTimeZone.FixedUtcNow(),
#"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 datetimezone}})
in
if Table.RowCount(otherqueryname)>0 then #"Changed Type" else null

Regards,

Pat

[mahoneypat]

You can use an if that calculates after your longest query to get close to that.  Or you can just make a DAX table with the NOW() function, so it recalculates after the queries load.

RefreshTable = {NOW()}

let

Source = if Table.RowCount(longestquery)>0, Date.From(DateTime.LocalNow()), null)

in

Source

Regards,

Pat

[qsong]

@mahoneypat 

This is my current query in advanced query to get starting refreshing time:

let
TodaysDate = DateTimeZone.FixedUtcNow(),
#"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 datetimezone}})
in
#"Changed Type"

Where will you add if? Thank you for your details.