Refreshed but Still Stale Data Report Needed

Hello, at work we have a model of around 60 tables pulled from myriad of sources including sharepoint, Kusto, etc. Some groups of people are responsible for keeping some data files/sources fresh for Power Bi to grab the latest data when refreshed, however sometimes people do not keep data files/sources updated, for instance they do not update a client list sharepoint file for two or more months, therefore even tough Power Bi is being refreshed it is doing so with old "stale" data, and that's a big problem.

I wonder if there's a way in which a log or record could be automatically created and updated  so it keeps countrows and file size for each time a table gets refreshed, if that's possible then we could do easily a report to detect no changes lets say for 90 days, and trigger an alert to go and tell responsibles abut it.

I am not sure if the solution could reside in a dataflow or probably we could use some built in dataset reporting feature, I am clueless! Thanks in advance for any suggestions or ideas or resources to explore, regards Juan