admin管理员组

文章数量:1221291

We have a Power BI Direct Query report which is experiencing occasional unexpected latency. The underline datasource is Snowflake and we use an On-Prem Data Gateway and Power BI Premium Service.

When we track the Power BI interactions using a SQL profiler trace, we see a StartTime for the slow SQL of time T; however, the query in Snowflake's query history shows a StartTime of T+n(where n is several seconds) The query executes in milliseconds with no time spent in queued state.

When we looked into gateway log, we find at time T it is showing query executing and in T+n it is showing ExecuteNextResultAsync. Not sure what is that means, but data volume is small what is being returned (only few rows).

Has anyone experienced similar latency/delay ? Is there a logical explanation of the delay?

本文标签： powerbiPower BI amp SnowflakeDelay in starting the query in SnowflakeStack Overflow

版权声明：本文标题：powerbi - Power BI & Snowflake - Delay in starting the query in Snowflake - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1739295326a2156878.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。