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 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

Need Help

3 Replies

  • 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

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Helper II rankHelper 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.