Forum Discussion

qsong's avatar
qsong
Helper 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
Microsoft Employee
5 years ago

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's avatar
qsong
Helper II
5 years ago

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.