Forum Discussion

andreas_franz's avatar
andreas_franz
Regular Visitor
8 years ago

OData refresh called multiple times

Hi,   I have a Power BI Destop application that accesses 1 Data Source which is an OData feed (from SAP). The OData feed is quite big (~650 MB) and when calling it from a web browser or SAP it take...
andreas_franz's avatar
andreas_franz
Regular Visitor
7 years ago

Hi Chandra,

 

unfortunately not. In the end I used a different way of getting the data - but this only works with getting data. I directly connect to the HANA database to a SQL view that pulls the data in the desired way (logic that I previously included in the OData code is now in the SQL command). This is also way faster in general as for us we have a gateway before the SAP system that has the data. and by directly accessing the database we avoid the gateway and SAP database access delays.

 

Not what I was looking for in the beginning but so far it works for us.

 

Best regards,

Andreas

acmpbi's avatar
acmpbi
Frequent Visitor
7 years ago

Hi Andreas,

 

Thanks for your Response.  I am pretty much doing the same what you did. I am using HANA Connector for now.But would like to see OData Connector working with out any performance issues.

 

Regards,

Chandra.

  • thoward120's avatar
    thoward120
    New Member
    6 years ago

    Was there ever a resolution for this? I'm running into the exact same issue now.

  • thoward120's avatar
    thoward120
    New Member
    6 years ago

    For anyone else who may be running into the same issue: the requests are not actually duplicates. If you look at the query string from the URI of each request, you will see that they are requesting different resources. In my case, one request was for Top X rows, one was requesting the model, and another was the actual GET request. 

    If you're using the OData provider, it's up to you to handle these requests accordingly.