Several organizations use a dedicated BI tool to visualize data and generate reports from multiple/various software tools that are used across an organization. Viewing such consolidated data on a single dashboard will provide the management with a clear picture of what’s happening in the organization. In order for this to work, relevant data from multiple business tools need to be exported and pushed into the BI tool for generating reports. 


The data export feature in Freshservice allows you to schedule the export of data and feed it into your BI tool either through a downloadable file or an API URL. 


To schedule a data export:

  1. Click on Analytics from the left sidebar. 

  2. Go to Settings and then select Data Exports

  3. Click the + New Export option on the top right corner to schedule a data export.

  4. If you want to schedule a data export for the Changes module. Select changes from Module Name.

  5. Choose the scheduling interval. It can be daily, weekly, or monthly.

  6. Use the view and the Basic filter option to filter the data you wish to export. 

  7. You can filter your data based on various parameters such as date, properties, associations, etc.

  8. You can choose the fields that have to be exported.
  9. The API URL will hold the link to the export file. Feeding the API URL into your BI tool will allow it to automatically fetch data from Freshservice. 
  10. Once done, click Save.


After scheduling the data export, you can view them all under the data exports view under Analytics. The download icon next to each schedule will allow you to browse through the past data and download them if needed. This will be helpful when your BI tool, for some reason, fails to fetch data from the API URL on a particular day. Under such circumstances, you can manually download the data for that particular date and import it into your BI tool. 


There is also the option to delete any of the scheduled data exports from this view. 



Note: While importing using the Power BI, ensure the API URL has the sub-domain URL of the freshservice instance(ends with freshservice.com) and not the CNAME URL for import to be successful.