Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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!