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

https://docs.bestpractical.com/rt/5.0.2/RT/Ticket.html#LastUpdated

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