英文:
Why is MS Excel Power Query sending multiple requests to Olingo V4 spring boot service
问题
我使用Olingo库来公开Odata端点。目标是从任何工具或Excel Power Query访问/odata/models端点。然而，当从Excel Power Query调用时，我看到两个连续的请求被发送到同一个端点。当我尝试从Postman调用相同的端点时，这种情况并不会发生。我想知道是否有人在使用Olingo Odata V4和Spring Boot时，从Excel调用时曾经遇到过这种情况？这对性能有一定的影响，因为每个调用都会访问数据库。
我尝试进行调试，但无法确定是内部调用导致了这个问题，还是Excel在进行双重调用。
英文:
I have used the Olingo library to expose Odata endpoint. Goal is to access /odata/models endpoint from any tool or Excel power Query. However, when the call is from Excel Power Query I see two requests being fired for the same endpoint one after the other. This doesn't happen when I try the same endpoint from Postman. I want to know if anyone has ever seen this happening while using Olingo Odata V4 with spring boot when called from Excel? It is a bit of a performance concern as each call strikes the database.
I tried debugging but just not able to analyse if an internal call causes this or if excel is making this double calls.
答案1
得分: 0
虽然这并不完全解决你的Olingo Odata V4应用程序的问题，但这是一个非常通用的解释，说明为什么会发生这种情况。隐私检查、列分析、缓存结果、连接器设计等都可能导致在同一查询中对同一源进行多次访问。
https://learn.microsoft.com/en-us/power-query/multiple-queries
希望这能帮助你理解或进一步研究。
英文:
While this doesn't exactly address your Olingo Odata V4 application, this is a very general purpose explanation of why it is happening. Privacy checks, column profiling, caching results, connector design, etc could all cause multiple hits to the same source within the same query.
https://learn.microsoft.com/en-us/power-query/multiple-queries
I hope this helps understand or direct further research.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论