Zendesk app custom fields

[I_ia]

Hi!

I can't use Power BI Desktop to import data from Zendesk because of API Result Limits. Or would that be solved? So I use Power BI Zendesk APP but it doesn't bring custom fields. Is it possible to get these added to APP? 

[antonstorozhuk]

Hello @I_ia 

Just in case you're still looking an easy way to exoprt your Zendesk data including custom fields, please refer to the app we've built: https://www.zendesk.com/marketplace/apps/support/834457/power-bi-connector-by-alpha-serve/

Feel free to reach out support team at support@alpha-serve.com if you need any assistance.

Best regards,

Anton

[Anonymous]

I put together custom power query code for zendesk & a custom connector.

https://community.powerbi.com/t5/Desktop/Custom-Zendesk-Connector-Power-Query-Code/m-p/2413666#M8648...

[v-diye-msft]

Hi @I_ia 

what are the API limits? could you please kindly share the error details? also, I believed you have tried to connect it using power bi service: 

https://docs.microsoft.com/en-us/power-bi/service-connect-to-zendesk 

For the custom field requirement,  you might try below workaround:

it is not the best solution, but it works for smaller databases.

Assuming  the custom ticket fields is missing:

1) Get data -> make sure to get the "Tickets" table

2) Edit query

3) Duplicate the "Tickets" table (right-mouse -> duplicate)

4) Remove all columns except "Ticket ID" and "Custom fields"

5) Press the arrows of the "Custom fields" column -> "Expand to new rows"

6) Press the arrows of the same column -> Select both "ID" and "Value" and press ok.

7) Change the type of the "Custom_fields.ID" into a whole number and the "Custom_fields.Value" field into a string.

Highlight "Custom_fields.ID" -> go to "Transform" tab -> "Pivot Column"

9) Make sure to select "Custom_fields.Value" AND press the (almost hidden) advanced tab in the window, select: don't aggregate

10) You can now change the titles of the custom fields ID so it is easier to work with. 

11) Close and save the query editor

That's it. Good luck!

[I_ia]

If I tried to import data (Zendesk beetta) to Power BI desktop, I got an error message: OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from
https://rauhava. zendesk.com/api/v2/search.json?page=11&query=type%3Aticket (422): Unprocessable Entity..

I tried your instruction but got the same error message.

Because I can't bring information, i tried to use the server app. The problem is that I can't get custom fields there. 

[Anonymous]

Hi all,

We are having the same issue and cannot find any proper solution. I cannot remember if it will work, but you might try to keep the latest 1000 rows. It is not a solution for the whole dataset, but if you make filter based on latest created tickets, you might have the last 1000 tickets out for reporting.