Epose Semantec Model Last refresh

[Tango2310]

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

[Anonymous]

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]

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

[lbendlin]

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]

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

Last Refresh Date = NOW()