Skip to main content
  • EN

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

Did you ever find a solution to this that did not involve the above reply? I am experiencing the same issue and would love to figure it out.

 

​@bhota, ​@joestract The value of the field ‘Resolution Time in Bhrs’ in data exports is expressed in milliseconds and not hours. Hence, you see large numbers under this field in the data exports. The ‘in Bhrs’ signifies ‘within business hours’; it doesn’t stand for the unit of measure being ‘hours’. Hope this clarifies.

Reply


Terms of Use