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