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