Request Tracker and Power BI

I am trying to export the data from RT for use with an case overview dashboard in power bi.

It seems the resolved date is not correctly set when a case is resolved and a lot of cases have 01.01.1970 as the resolved date.

So I am trying to find out if the last date a comment or update was made against a case is available from the database.

Does anyone know about this?

Thanks in advance

I’m not sure where in the db this is set, but tickets track when they were last updated