Question

PowerBI Integration

  • 7 September 2022
  • 7 replies
  • 1536 views

Badge

Anyone having any luck using PowerBI to pull metrics out of FreshService as I am not a big fan of their analytics section???


7 replies

API Power: Use Power BI queries to tap directly into Freshservice's API and pull the data you need.

FreshInsights (Paid): This paid add-on provides pre-built dashboards and reports for Freshservice data in Power BI

I have PBI template that just does that using native Power BI Queries.

No export needed… has been used by many users before...

 

See here for more information :

PowerBI – Using FreshDesk Web Services API

 

This approach demonstrates the flexibility and potential of Power BI's native query capabilities when used in conjunction with web service APIs, enabling customized data analysis and reporting across different platforms.

This works for FreshDesk but not for FreshService?

thank you,

 

Badge +1

I have PBI template that just does that using native Power BI Queries.

No export needed… has been used by many users before...

 

See here for more information :

PowerBI – Using FreshDesk Web Services API

 

 

This works for FreshDesk but not for FreshService?

thank you,

I found that the basics for FreshDesk apply also for Freshservice. I connected to FS using the API and was able to get all the info I needed for my metrics. So far I got anything from SLA, FCR and distribution up to detailed info on specific issues.

 

thank you!

Badge +1

I have PBI template that just does that using native Power BI Queries.

No export needed… has been used by many users before...

 

See here for more information :

PowerBI – Using FreshDesk Web Services API

 

 

This works for FreshDesk but not for FreshService?

thank you,

Badge

I have PBI template that just does that using native Power BI Queries.

No export needed… has been used by many users before...

 

See here for more information :

PowerBI – Using FreshDesk Web Services API

 

 

Userlevel 5
Badge +5

Hello @Mike.Borst5301 

We can create a Data Export from the Analytics Module,

 

You can copy the API and navigate to Power BI to export the data from Web, You can paste the link received from Freshservice for Data Export and the Data would be formatted in Power BI.

 

Hope this helps!

Userlevel 7
Badge +13

I have customer that has, you need Pro and setup the export in analytics. 

Reply