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

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 Post Patron
Post Patron

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). 

Highlighted
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 Post Patron
Post Patron

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 Skilled Sharer
Skilled Sharer

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 Post Patron
Post Patron

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 Skilled Sharer
Skilled Sharer

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
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