Forum Discussion

qsong's avatar
qsong
Icon for Helper II rankHelper II
5 years ago

Report dataset ending refreshing time PowerBI

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 tim...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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