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?