A data export is scheduled in the path Analytics > Settings > Data Export to export all Tickets through the API that is consumed by Power BI application. The field Resolution Time in Bhrs shows number like 58453000 which does not make any sense. Foe the same ticket the actual data is
Created Date - Dec 6, 2021 9:45 AM
Closed Date - Dec 10, 2021 7:36 AM
Time taken - 16hrs 14mins
However in the report the Resolution Time in Bhrs is 58453000.
This field shows similar big number for all tickets.