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.
You can calculate the resolution time in Power BI using DAX.
I have a PBI template that just does that using native Power BI Queries.
No export needed, no limitations… has been used by many users before...
See here for more information :
PowerBI – Using FreshDesk Web Services API