Forum Discussion

I_ia's avatar
I_ia
Frequent Visitor
6 years ago

Zendesk app custom fields

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? 

Need Help

5 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    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's avatar
      I_ia
      Frequent Visitor
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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.