Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

OData performance issues

We have OData endpoint where every record contains also curve data (array of {x: number, y:number} objects). Those curves have ~600 points and there are arround 30 curves per record. In other words, ...
Need Help
trick73's avatar
trick73
New Member
2 years ago

Hi,

I'm experiencing same disappointment with OData in PowerBI.

 

OData involves pagination by design, so many requestes have to be issued when dealing with "big" data sets.

My OData server has a default of 1000 rows per page. Increasing the page size on the server side has given some benefit but still it remains twice as slow in the average compared to a massive json download.

 

I have written a small Python script to download the same OData feed and the performance gets sensitively better though still worse than the best case.

So I suspect than beyond pagination Power BI does something else that makes it much slower.

 

Some reference numbers:

- 1.7 million rows dataset

- 5.5 minutes with Power BI OData Feed

- 3 minutes with Python OData Feed

- 2 minutes one-shot json Download

 

Regards

 

Riccardo