Recent searches


No recent searches

Connecting Zendesk to Power BI - the results in the number of tickets returned via the app "Zendesk for Admins" show an important amount of missing items



Posted Nov 08, 2022

Hi,
 
My team and I are facing a major roadblock with the Zendesk app for Power BI (Zendesk for Admins -see attachment below).
 
 
After connecting this app to our Microsoft platform (following the guidelines hereafter: Connecting Zendesk to PBI) in order to get Power BI dashboards and a set of reports providing insights about our ticket volumes and agents' performance, we have identified a great disparity in the number of tickets displayed within those reports. 
 
For instance, when we wanted to see the requests that our team has handled since the beginning of the year, half of the tickets created within that timeline would not appear within the reports, which could be quite alarming (see attachments below). 
 
 
For us to get -almost- similar figures, we seemed to be limited to requests created/updated within the last quarter, except for a few -less than 10- exceptions (see attachments below).
 
 
Even then, we faced great discrepancies in terms of "solved" tickets (see attachments below).
 
 
A documentation on the PBI website mentioned a change in the returned results for large queries through the Zendesk Support Search API that returns tickets, users, and organizations (see attachment below).
 
Could this be the reason behind the large variations that we saw between the Zendesk reporting and Power BI?
 
If so, could you help us work around this so that we could get precise data via the Zendesk app for Power BI?
 
Looking forward to hearing from you.
 
Kind regards,
Michel

0

3

3 comments

Hi Michel,

It is now possible to export any Zendesk Support data to Power BI using Power Bi connector from Alpha Serve. 

https://www.zendesk.com/marketplace/apps/support/834457/power-bi-connector-by-alpha-serve/?

Khrystyna 

-1


Has anyone been able to figure this out without a paid for connector?

0


image avatar

Erica Girges

Zendesk Developer Advocacy

Hi Shelby, 
 
I would look into using Export Search Results from the Ticketing API as this is specifically designed for search queries that will return more than 1000 results. 

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post