How do you guys pull in Zendesk data? Below are some of the ways I've found, but none (seem) great. Let me know if I have misconception(s): Get Data > Zendesk connects, but is incredibly slow. Using the Zendesk App works, but that just gives preset visuals. Not the raw data that can then be combined with other data sources / interpreted via measures. Create custom reports in Zendesk, then manually export those to files - connect to the files. Manual steps aren't good. Use the API to pull Zendesk data into a data warehouse, then connect Power BI to that warehouse. Bit beyond my current abilities, and we don't really have available staff to implement thatOutsourcing the API/Warehouse to something like Stich. Seems viable, just...we pull in a lot of data to Power BI, this is the first source that we'd be using an external service / all this hassle for. Compared to our other data sources (relatively easy to connect to and import from)- all these options kind of suck. How do you pull in Zendesk data?

mmace1,You can connect to Zendesk.pbit in Power BI Desktop and combine other data sources in same PBIX file.Reagrds,Lydia

Forum Discussion

Impactful Individual

7 years ago

Solved

Below are some of the ways I've found, but none (seem) great. Let me know if I have misconception(s):

Get Data > Zendesk connects, but is incredibly slow.
Using the Zendesk App works, but that just gives preset visuals. Not the raw data that can then be combined with other data sources / interpreted via measures.
Create custom reports in Zendesk, then manually export those to files - connect to the files. Manual steps aren't good.
Use the API to pull Zendesk data into a data warehouse, then connect Power BI to that warehouse. Bit beyond my current abilities, and we don't really have available staff to implement that
Outsourcing the API/Warehouse to something like Stich. Seems viable, just...we pull in a lot of data to Power BI, this is the first source that we'd be using an external service / all this hassle for.

Compared to our other data sources (relatively easy to connect to and import from)- all these options kind of suck.

How do you pull in Zendesk data?

Anonymous
Not applicable
7 years ago
mmace1,

You can connect to Zendesk.pbit in Power BI Desktop and combine other data sources in same PBIX file.

Reagrds,
Lydia
- scotton
  Frequent Visitor
  5 years ago
  Thanks a lot! I was running in circles until now
  - max_liepelt
    New Member
    2 years ago
    Hi Scotton, could you please elaborate, how you got the connection Zendestk - Power BI working? I am currently facing the problem that using the free connector app in the power BI apps only allows me to draw limited data, so not all tickets. Are you able to show all ticket data in power BI?
antonstorozhuk
Helper V
3 years ago
Hello mmace1
We're developers of Power BI Connector https://www.zendesk.com/marketplace/apps/support/834457/power-bi-connector-by-alpha-serve/ it allows you to connect Zendesk to Power BI in less than 5 minutes. You may try it for free. Let us know if you need any assistance.
Cheers,
Anton
drinko
Helper I
5 years ago
I get the following error. Are there any suggestions to get this to work?
Anonymous
Not applicable
4 years ago
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