cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ceortega Regular Visitor
Regular Visitor

Zendesk Ticket Limitation

Does Power BI set a limitation on the number of tickets?  I am going through Zendesk tickets created in 2015 and it looks like I am missing a lot of January, February, and March ticket volumes. 

 

I did some research and it says that it could be Zendesk archiving where Zendesk archives tickets after 120 days after closed.  Could that be the case where I can't trace and agree prior periods because the tickets were archieved?

 

Also, if they are archieved how can I access that information in Power BI?

Christopher E. Ortega, MBA
Manager, FP&A
4 REPLIES 4
PowerBIGuy Member
Member

Re: Zendesk Ticket Limitation

There are no limits set on the Power BI side. If your using the Content pack i would sugguest connecting to zendesk via the Power BI desktop and see if you get the same results. 

Business Intelligence Architect / Consultant
Highlighted
ceortega Regular Visitor
Regular Visitor

Re: Zendesk Ticket Limitation

I got the same amounts. After doing some research last night, what is evident is not on Power BI's side but Zendesk archieves 120 days after ticket has been closed.   And the API connection doesn't pull acheived tickets from Zendesk which significantly Power BI ability to pull full year of tickets created.  

 

Here is the exact link for others to reference.  This is huge limit from Zendesk and on Power BI having some way to access achieved tickets from Zendesk but I am surprised that no one has brought this issue up yet.

 

https://support.zendesk.com/hc/en-us/articles/203657756-Ticket-Archiving

Christopher E. Ortega, MBA
Manager, FP&A
PatrickA Frequent Visitor
Frequent Visitor

Re: Zendesk Ticket Limitation

We are also using the Zendesk Connector and expierence the same issue.

It renders using PowerBI for Zendesk almost useless as we don't have all the data that we need.

Did you find another way to get all the data into PoweBI, or is there an updated zendesk connector that does get all the tickets?

PatrickA Frequent Visitor
Frequent Visitor

Re: Zendesk Ticket Limitation

And I also found the answer, use the API to get all the data and import is seperately into PowerBI

 

https://support.zendesk.com/hc/en-us/community/posts/204617638-Microsoft-Power-BI-and-Zendesk-data

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 195 members 2,497 guests
Please welcome our newest community members: