Update Zendesk Beta Plugin to support new Zendesk API changes
I cannot get data from Zendesk using the Power BI Zendesk Beta plugin anymore, because Zendesk has changed their API, and Power BI will have to make some adjustments for it to work. It's mentioned here: https://develop.zendesk.com/hc/en-us/articles/360022563994--BREAKING-New-Search-API-Result-Limits?fl...
If this isn't updated, we will continue to receive this error when refreshing "OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://jssi.zendesk.com/api/v2/search.json?page=11&query=type%3Aticket' (422): Unprocessable Entity"
Will Microsoft Power BI be creating an update to the Zendesk beta plugin to address this in the near future?
Is there a work around we can use in the mean time?
It would be helpful if the connector could be configured so that we can use filters to get under the 1000 record limit since we don't nearly have 1000 open tickets at once. We'd probably get the last 6 months worth of tickets or something like that. My understanding is that other connectors such as the google analytics connectors will change the underlying api calls based on the filters applied so it seems like something similar could be done with this.
In the meantime, we are trying a workaround by using the Zendesk App (https://docs.microsoft.com/en-us/power-bi/service-connect-to-zendesk) and then loading that dataset into a new Power BI report by using the Power Platform -> Power BI datasets. It doesn't seem to support our custom zendesk fields but at least it gives us the basic ticket data.
Please update the zendesk connector for Power BI!!
Daniel Shapiro commented
Fundamentally there seems to be a disconnect between the way Zendesk intends for its latest API to be used and the way that Power BI works (AFAIK).
Zendesk now says that their "Incremental API" should be used for reporting in BI tools:
- See the table at the top of this page: https://develop.zendesk.com/hc/en-us/articles/360022563994
- See this comment by Zendesk dev support: https://develop.zendesk.com/hc/en-us/articles/360022563994/comments/360003446454
But the usage notes for the Incremental API say "You shouldn't use this API to repeatedly export complete lists of items.", and my understanding of how basic Power BI queries/data sources work is that they require exactly that.
The Incremental API also has a rate limit of 10 requests per minute, with a maximum of 1000 results per request, so there's effectively a limit of 10K results on anything that Power BI service would be able to refresh: https://developer.zendesk.com/rest_api/docs/support/incremental_export#usage-notes
Any news with this issue? any workaround?
One of the reasons we chose zendesk as a platform was microsofts connector. Please fix this.
A fix to this is essential
Mike Brennan commented
Link to things from Zendesk's side. https://develop.zendesk.com/hc/en-us/articles/360022563994--BREAKING-New-Search-API-Result-Limits?page=3#comments
It will be really appreciated that MS Power BI team could create an update to Zendesk API changes since it is impacting our daily task. No workaround found so far, please inform if any info could be helpful, thanks.
This impacting our daily metric needs.
Great you already mentioned this. Wasnt able to find a workaround. We have a big and important Zendesk report, so solving this would be very very appreciated