Power BI

Needs Votes

Update Zendesk Beta Plugin to support new Zendesk API changes

Vote (106)

Toks on 25 Oct 2019 21:03:45

Hi,

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"

1. Will Microsoft Power BI be creating an update to the Zendesk beta plugin to address this in the near future?

2. Is there a work around we can use in the mean time?

Thanks.

Comments (13)

Comments (13)

Jane Hobden on 23 Feb 2024 11:39:26

RE: Update Zendesk Beta Plugin to support new Zendesk API changes

Is there a workaround for this as it doesn't appear fixed yet?

Romain Miroux on 13 Nov 2020 20:43:53

RE: Update Zendesk Beta Plugin to support new Zendesk API changes

Hey,
Could we have an update on this issue?
It doesn't look like a big complex change for you, could be done easily and help us a loooot :)

Shawn Namdar on 16 Aug 2020 04:19:24

RE: Update Zendesk Beta Plugin to support new Zendesk API changes

Please Fix This!

Lori on 16 Aug 2020 04:18:14

RE: Update Zendesk Beta Plugin to support new Zendesk API changes

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.

Power BI User on 16 Aug 2020 04:18:13

RE: Update Zendesk Beta Plugin to support new Zendesk API changes

Please update the zendesk connector for Power BI!!

Daniel Shapiro on 16 Aug 2020 04:17:35

RE: Update Zendesk Beta Plugin to support new Zendesk API changes

'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