PowerBI

  • 15 February 2018
  • 11 replies
  • 120 views

Hi,

I'l like to use powerbi to make some reports.

I discovered this: https://apps.freshdesk.com/freshdesk_on_powerbi/

Looks great.

Then I received the mail below, then nothing.

Do you know what I'm supposed to do?

Thanks

Matthieu



image




11 replies

Userlevel 1

Hello Matthieu,


This should be a confirmation that the integration process has kicked off as expected. The app has been developed by a third party and listed on our marketplace. You can reach out to freshdesksupport@radiare.com in case if you have any questions regarding this.


Cheers!

Matthieu Giorgini, did you manage to get this working?


Nope. Actually, I understood nothing about the process :(


The third party Power BI solution that FreshDesk is promoting is from a third party.  I suggest that if FreshDesk would improve their API, the third party would not be necessary and direct Power BI integration would be possible.  ZenDesk already has direct Power BI integration and they have published an App in the Power BI marketplace.  It would be a wise decision for FreshDesk to do the same.


I agree to this point. Freshdesk claims to have about 150.000 businesses that rely on freshdesk, but freshdesk is useless if you can't do proper analysis, and to be frank the reporting tool within freshdesk is very limiting.


Same issue here. Waiting them reply my email.


BTW, almost 1 year already, and we have not natively integration from Freshdesk side?


Userlevel 1

Hello,


We're in talks with the 3rd party to standardise the integration and also to be more responsive to the requests. We understand that the 3rd party integration is definitely not the solution that you're looking for but for now, it is the best possible option. We'll evaluate the request for native integration in future if there are more requests to integrate PowerBI with Freshdesk. 


On a different note, few of our customers have found the Ticket activities export to be useful in extracting data from Freshdesk. I've also seen several dashboards set up in PowerBI with the help of the data available in the Ticket properties export. Did you get a chance to explore either of these?


Cheers!

Hi,


I'm able to connect to FreshServia via ODATA. I an see the relevant tables.


BUT in table users, email-addresses are anonymized like p******r@company.com ... I need them to match this with another table on an internal SQL server...


Thanks,

Philip


Hi,


second question: Where do I find the reported minutes/hours for a specific ticket?


Thanks,

Philip


Hi,


no comments? :(


You can call the API and loop through the pages in Power BI setting up a dataset that you can set to refresh on a schedule. Feel free to reach out if you are struggling with implementing this.

 

https://www.aviationithelp.com/contact-us

Reply