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
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        is that a faster approach then? 🙂 

        I haven't tried yet. Iam still wondering if its worth trying 🙂 

         

         

        lastly do i need to hard code everything from scratch ?

         

         

        Best