Forum Discussion
Zendesk Connector
Hi,
Recently we have been trying to use the Zendesk connector, which works in some cappacity, but is limited to the classic 1000 lines of data.
After exchanging with the Zendesk Support, they redirected me to the Power BI Support to get help here.
What we're seeing
What we're supposed to see
Apparently we're supposed to see this Zendesk Data connector, which doesn't restrict you to the 1000 line limit, but I'm only seeing the "Zendesk" connector. How could that be ? And how could I possibly change that ?
Thank you in advance,
Martin HOHLER
8 Replies
- Ritaf1983
Super User
Hi mhohler
The Zendesk connector in Power BI is limited to 1,000 records because of Zendesk’s API restrictions. This isn’t a Power BI bug but a limitation enforced by Zendesk’s Search API.
If you need to work with larger datasets, the documented alternatives are:
Split queries into smaller ranges (e.g. by date or ticket status) and combine them.
Load Zendesk data into a data warehouse like SQL, then connect Power BI to that.
Use third-party connectors such as CData that may provide more flexibility.
For more details, see Microsoft’s official documentation:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-to-zendesk
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983,
Thank you for the swift response !
That's also how I understood the problem but they told me the following :Could it be possible that a connector wouldn't appear on my hand ? Would you be aware of a more recent connector like the one they're refering to ? (link to their article : Using the Power BI Connector by Zendesk – Zendesk help)
Kind Regards,
Martin HOHLER- Ritaf1983
Hi mhohler
In Power BI, the connector itself is only a passive gateway. It exposes the data, but the actual limitations come from the source system you are connecting to—in this case, Zendesk.
You can certainly open a ticket with Microsoft Support outside of the forum, but realistically the limitation is on the Zendesk side. That’s why I would also recommend engaging directly with someone technical from Zendesk to confirm what options are available.
Link for openig a support ticket:
https://support.fabric.microsoft.com/support/If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello Rita,
Sorry for the late reply.
I don't think I'm able to submit a support ticket since I don't have a premium membership it seems.
The Zendesk support answered me the following :
Normally, you should be able to bring all the tickets, but the API call must apply filters. You might need to reach out to the PowerBI support to know if their integration comes with filters.
As per our documentation: You can define filters to narrow your search results according to resource type, dates, and object properties, such as ticket requester or tag.
For example, you can bring tickets for 3 months and other 3 months and so on. More info: https://developer.zendesk.com/documentation/api-basics/working-with-data/searching-with-the-zendesk-api/
---
Currently I'm only getting big tables for tickets only limited to those 1000 lines. How could filters impact this ?
Thank you in advance,
Martin HOHLER
v-saisrao-msftCommunity Support
- v-saisrao-msft
Hi mhohler,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
- v-saisrao-msft
Hi mhohler,
May I know if you have raised the support ticket and whether the issue has been resolved?
Thqnk you.
