Forum Discussion

pvgasse's avatar
pvgasse
New Member
9 years ago

zendesk form type is not imported

Hi,   We use Zendesk as a support tool for our customers. They can create tickets with questions about our different products. In order for them to specify for which product they want to submit a ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

pvgasse,

Do you use Zendesk content pack to connect to your source in Power BI? Is the ticket form a custom field? Based on the aforementioned official article, the content pack only includes data on the following:

- Users (end users and agents)

- Organizations

- Groups

- Tickets

I would recommend you use Zendesk connector in Power BI Desktop to connect to your data source and check if the form field is imported.

Regards,
Lydia

pvgasse's avatar
pvgasse
New Member
9 years ago

Hi Lydia,

 

Thank you so much for looking into this !

 

I used the PowerBI app from within Office 365. I was able to connect to Zendesk and retrieve my data.

(I also tried with the PowerBI Desktop version, but appearently the Zendesk connector is a Beta version and I was not able to get connected.)

The forms we have defined is a standard Zendesk functionality. It is not really a field, a form allows you to show other fields depending on the type of form that was selected.

I have added a screenshot of the menu in Zendesk.

 

Do you have any experience with this ? Can you help me ?

 

Thanks in advance.

Regards,
Pamela

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    pvgasse ,

    I am not familiar with Zendesk form type. What error message do you get when you use Zendesk connector in Power BI Desktop?

    Regards,
    Lydia

    • pvgasse's avatar
      pvgasse
      New Member
      9 years ago

      Hi Lydia,

       

      I specified our Zendesk URl, then username and password, the next I got was : 

      System.Net.ProtocolViolationException: Cannot send a content-body with this verb-type.
         at System.Net.HttpWebRequest.CheckProtocol(Boolean onRequestStream)
         at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
         at System.Net.HttpWebRequest.GetRequestStream()
         at Microsoft.Mashup.Engine1.Library.Web.Request.GetWebResponse(WebRequest webRequest) ...

       

      Did I specify something wrong ?

      Would the PowerBI desktop be able to import the Form type? Does it do anything different then the online version ?

       

      Thanks,

      Regards,
      Pamela

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        pvgasse,

        When connecting to Zendesk in Power BI Desktop, do you enter same URL as that you use in Power BI Service? And please make sure that you use “Organizational account” in Power BI Desktop.

        In addition, Zendesk content pack in Power BI Service provides pre-defined reports and dashboard for you, accessing the Zendesk data source in PBI Desktop is just a connection to the base tables (or SQL views) in your source system, you would need to create reports by yourself.

        Regards,
        Lydia