Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Slow Azure DocumentDB dataload to PowerBI Desktop with dynamic RUs



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.




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.



Charlie Liao

Not applicable



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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors