Zendesk error

[Anonymous]

I have been working with the zendesk dataset for a couple of days now and everything was working well until recently where I keep on getting the following error when trying to refresh  "OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents (422): Unprocessable Entity."

I can view the preview table and even modify the information in the Query editor.

Can you kindly help,please

[antonstorozhuk]

Hello,

If your Power BI - Zendesk Connector is still broken, then you might want to try another option. We're developers of Power BI Connector https://www.zendesk.com/marketplace/apps/support/834457/power-bi-connector-by-alpha-serve/ it allows you to connect Zendesk to Power BI in less than 5 minutes. You may try it for free. Let us know if you need any assistance.

Cheers,

Anton

[jelgerbos]

It looks like Zendesk changed their API and this is causing issues.

You can only query the first 1000 rows.

https://develop.zendesk.com/hc/en-us/articles/360022563994--BREAKING-New-Search-API-Result-Limits?fl...

I hope Power BI will come up with a solution soon.