Analytics module in Freshservice allows you to generate intuitive reports for your service desk. Integrating Power BI with Freshservice enables you to scale up your analytics with extensive dashboards and reports to drive business results using actionable insights. 

How to Schedule an Export on Freshservice’s Analytics

In order to schedule a data export, 

  • Log into your Freshservice account and click on Analytics from the left sidebar. 

  • Inside Analytics, click on the drop-down menu on the top left corner and select Data Exports

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

  • Let’s say you wish to schedule a data export for the Changes module. Select changes from Module Name. Choose the scheduling interval. It can be dailyweekly, or monthly. Use the view and the Basic filter option to filter the data you wish to export. 

 

  • You can choose the fields that have to be exported.

  • 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. 

  • Once done, click Save

 


How to Integrate Power BI with Freshservice Analytics


Step 1: From Freshservice’s Analytics module, copy the API URL which holds the link to export the file. 







Step 2: Log in to your Power BI Desktop and click onGet Data. From the Get Data window, selectWeb and click on Connect.



Step 3: In the From Web window, paste the Freshservice API URL in the URL field and click on OK.



Step 4: Go to Basic Auth. Here enter your Freshservice Username and Password.





You can also use your FS User’s API key in the User name field (leave the password empty) and click on Connect




 


You will now receive your Freshservice data export file. You can use this file as your data source and start building reports in Power BI.