为什么 MS Excel Power Query 向 Olingo V4 Spring Boot 服务发送多个请求?

huangapple go评论97阅读模式
英文:

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.

huangapple
  • 本文由 发表于 2023年8月9日 11:04:36
  • 转载请务必保留本文链接:https://go.coder-hub.com/76864315-2.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定