OLE DB or ODBC error while connecting Zendesk

[Anonymous]

Hi,

I am receiving the below error while trying to load data from Zendesk to PowerBI desktop. Any ideas?

[Anonymous]

I have started a post compiling Power Query code for a custom connector to zendesk. https://community.powerbi.com/t5/Desktop/Custom-Zendesk-Connector-Power-Query-Code/td-p/2407620

[Griffin_BI]

You get the error 422 when you are returning more than 1000 rows using the ZenDesk connector. It's a limitation with the connector. 

[Anonymous]

Hi @v-eqin-msft 
I created the support ticket, and the support team asked to utilize the 3rd party ODBC driver i.e CData drivers which are paid. 
I am not sure if that is the correct resolution, as if there is a direct integration available then isn't that working and why no one is able to resovle that.

I hope this gets escalated.

Thank you

[v-eqin-msft]

Hi @Anonymous ,

You may check this post .

If you still cannot solve the issue,sorry for that, we do not found an effective solution.
We suggest you go to https://powerbi.microsoft.com/en-us/support/ ,scroll down and click "CREATE SUPPORT TICKET" for further help if you are a pro user.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.