cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmace1 Member
Member

Importing Data from Zendesk is very slow - common issue?

Hi, 

 

I've tried the built-in (beta) connector to zendesk, and give it our organization's URL in this format: 

 

https://OurCompany.zendesk.com

 

It's connects fine, but importing data is *slow*.  I'm accustomed to importing data from all over the place, but nothing has been remotely this bad.  

 

Anyone have any insight? 


Thanks!

7 REPLIES 7
Moderator v-yuezhe-msft
Moderator

Re: Importing Data from Zendesk is very slow - common issue?

@mmace1,

What version of Power BI Desktop do you use? How about you connect to the Zendesk PBIT file?

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.
mmace1 Member
Member

Re: Importing Data from Zendesk is very slow - common issue?

Thanks. 

 

June 2018 Desktop. 

 

Using that file - it errors out due to many-to-many relationships.  But, if I ignore that & say just try to refresh the Tickets - it goes 20 minutes without conclusion (at which point I gave up). 

Moderator v-yuezhe-msft
Moderator

Re: Importing Data from Zendesk is very slow - common issue?

@mmace1,

The performance issue could be caused by large amount of data. Could you please reduce the amount of your data by filtering and check if the issue still occurs?

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.
mmace1 Member
Member

Re: Importing Data from Zendesk is very slow - common issue?

@v-yuezhe-msft

 

Things will definitly load - it's just the speed. 

 

E.g, pulling in: 

  • Zendesk table with 20 rows - no problem. 
  • tickets table - I gave up before completion
  • 1 column of the tickets table - I gave up before completion
  • Top 100 entries of 1 column of the tickets table - no problem. 
  • Top 1000 entries of 1 column of the tickets table - starts feelig slow, but is workable. 

 

So it is the amount of data - but the workable amount of data is incredibly low, due to the incredibly slow speed.  

jcarville Established Member
Established Member

Re: Importing Data from Zendesk is very slow - common issue?

Has anyone had any further updates on the speed of Zendesk refreshes?

 

My Zendesk report is built using the Zendesk (beta) connector, and takes a ridiculously long time to refresh given the size of the data model (not too big).

 

You can see from my images below the refresh takes nearly 2hrs to complete and the number of rows in each of my tables.

 

Zendesk refresh times.pngRefresh timesZendesk table sizes.pngData model and no. of rows per table

mmace1 Member
Member

Re: Importing Data from Zendesk is very slow - common issue?

I certainly haven't at least.  Our 'solution' was to just not pull Zendesk info into Power BI.

Abduvali Established Member
Established Member

Re: Importing Data from Zendesk is very slow - common issue?

Hi @v-yuezhe-msft 

 

I'm having the same issue when puuling data from Zendesk into Power BI.

 

I have selected just 2019 data and its spinning for more than 30 min now.

 

Any workable solution?

 

Thanks

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors