Forum Discussion

Tango2310's avatar
Tango2310
Helper I
2 years ago

Epose Semantec Model Last refresh

Hi,

I would like to put in my report, the last refresh date of the Semantec Model.

 

 

Where could I find that?

 

Thank you

 

Todd

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Don't do it, the Last Refresh Date is largely meaningless. Instead, identify a date column in your actual data that can indicate "freshness" like Last Order Date.

  • ahadkarimi's avatar
    ahadkarimi
    Solution Specialist
    2 years ago

    this measure could help, and if you encounter any issues, let me know.

    Last Refresh Date = NOW()

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Tango2310 ,

     

    I think you can try to add a new query table with function DateTime.LocalNow() in Power Query Editor and then show the Last Refresh Data in a card visual.

    let
    Source = #table({"Last refresh"}, {{DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Last refresh", type datetime}})
in
    #"Changed Type"

    For reference: Solved: How to include the 'Latest Refresh' date and time ... - Microsoft Fabric Community

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Tango2310's avatar
      Tango2310
      Helper I
      2 years ago

      With respect, Anonymous lbendlin ahadkarimi , you are all missing the point.

       

      I would like to expose when the semantec model was last refreshed. This is exposed in the Power BI dashboard as per the screenshot I showed above.

      Since the Semantec model can only be refreshed a maximum of 8 hours per day, I would like to exposes this date.

      Thanks

      Todd