cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Timmofo
Frequent Visitor

Zendesk custom ticket fields missing

Hello everyone,

 

I am having problems with the integration of Zendesk with Power BI. It seems that the custom fields I created with Zendesk (which are a must for analytics and visualisations) do not get imported through the Zendesk import service.

 

Am I missing something?

 

With kind regards,

Tim

1 ACCEPTED SOLUTION

Accepted Solutions
Timmofo
Frequent Visitor

Re: Zendesk custom ticket fields missing

Found a work-around for this issue.

It might not be the best solution, but it works for smaller databases.

 

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. You now have a table which you can link to your ticket IDs in the "Relationships" window. Good luck!

View solution in original post

6 REPLIES 6
Moderator v-yuezhe-msft
Moderator

Re: Zendesk custom ticket fields missing

@Timmofo,

It doesn't support Zendesk custom fields in Power BI, there is an idea about this issue, please vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13239564-support-for-zendesk-cust...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Timmofo
Frequent Visitor

Re: Zendesk custom ticket fields missing

Hello Lydia,

 

Thank you for your response.

It seems that this issue has been reported 2 years ago, is there a reason why this crucial functionality has not been implemented yet?

 

Kind regards,

Tim

Moderator v-yuezhe-msft
Moderator

Re: Zendesk custom ticket fields missing

@Timmofo,

When the idea is voted by many people, Power BI team will consider to improve the feature. 

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Timmofo
Frequent Visitor

Re: Zendesk custom ticket fields missing

Hello Lydia,

 

That makes sense, thank you for the clarification!

 

Timmofo
Frequent Visitor

Re: Zendesk custom ticket fields missing

Found a work-around for this issue.

It might not be the best solution, but it works for smaller databases.

 

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. You now have a table which you can link to your ticket IDs in the "Relationships" window. Good luck!

View solution in original post

afranklin
New Member

Re: Zendesk custom ticket fields missing

Hello. I do not see Tickets table.  When I click on Get Data I only see Discover Content and Create New Content.  What should I choose to get the Tickets option. 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors