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

v-yuta-msft

 

Thanks for reply, but unfortunatelly it's not helpfull at all.

I can use google myself and I already read those before I posted this question.

 

I'm looking for an answer to question why OData feed is much slower then downloading the data manually and using them as JSON source. Is it doing some validation against model which is time consuming or what?

 

Anyway even then the performance is terrible. Somebody with experience could tell if it's even worth a try to optimize this. Is our approach - download all and filter in Power BI, wrong for our data model? Is direct query - where we will filter data serverside based on user selected parameters better approach for this case?

 

Regards,

Michal

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

 

 

 

Have you find an answer to the problem? 

 

I have same issue with OData it is just terrible! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    Unfortunatelly no.

    PowerBI is not cappable of processing high-volume OData payloads effeciently. If your endpoint supports filtering and projections ($filter, $select), you can apply those operators by yourself and import result into PowerBI as plain JSON.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, 

       

      How do I know if my end poind supports that? 

       

      Can you please elaborate? Iam not well experienced in that part. 

      Your help is really really appreciated.

       

       

      Regards