Forum Discussion
OData refresh called multiple times
andreas_franz,
Have you make any calculations in Query Editor and create other reference queries? Please review the following blog about Table.Buffer.
https://blog.crossjoin.co.uk/2016/11/20/referenced-queries-and-caching-in-power-bi-and-power-query/
Regards,
Lydia
Anonymous
The query I provided is the only query and it is the complete logic. There are no calculations and no other queries are referenced.
I had seen the blog in a web search also but it seems to me that Table.Buffer is only applicable when having more than 1 query which is not the case for me.
Regards,
Andreas
Hi Andreas,
Were you able to find a resolution for multiple reads of OData Feed to SAP. I am facing the exact same problem.
I have a OData Feed which roughly takes 3 minutes to fetch data in Browser but the same is taking 15 minutes when called from Power BI.
Any help is greatly appreciated.
Thanks,
Chandra.
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
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.
