cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Slow Azure DocumentDB dataload to PowerBI Desktop with dynamic RUs

Hi

 

I'm pulling data from Azure DocumentDB to Power BI Desktop, and it is untolerable slow to load to data from this source. This is even if I have just plain collection data from Azure DocumentDB - and nothing else in Desktop report.

 

For example: 10k rows, 40 columns ---> 10 minutes. Too slow!Our IT guy told me we have dynamic RU purchase so it should not be because of this.

Any idea what's wrong? This was working fine like 1,5 months ago, but now it is totally jammed all the time.

2 REPLIES 2
v-caliao-msft
Microsoft
Microsoft

@Anonymous,

 

For example: 10k rows, 40 columns ---> 10 minutes.
40 columns? Do you need all of them?  Generally, columns impact perfomance much more than rows. Please remove the colums that won't be used and check if this issue persists or not.

 

Regards,

Charlie Liao

Anonymous
Not applicable

@v-caliao-msft

 

Hi thanks for reply.

 

Otherwise good thinking, but the thing, my connection was working like a jar of butterflies - that is of course - like fast and great before.

 

Besides, c'mon, I am not pulling 10 million rows with 200 columns... that would be much... a few 10K rows and couple of columns should be a walk in a park. What if I was working for a really big organization with millions of database rows in a casual report? Power BI should be lightning fast!

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors