Forum Discussion
Snowflake connexion too slow
- 2 months ago
Hi PBI_2K26 ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Based on your issue there are few debug steps which you can try and reslove your issue.
- Network latency between the Power BI client/service and the Snowflake environment.
- Snowflake connector or driver version (ensure the latest Power BI Desktop version is being used).
- Authentication method (OAuth, SSO, external browser authentication, etc.), as repeated authentication or token validation can introduce delays.
- Gateway performance, if Power BI Service is using an On-premises Data Gateway.
- Proxy, firewall, VPN, or SSL inspection that may be affecting communication between Power BI and Snowflake.
- Metadata retrieval from Snowflake. Sometimes loading the list of databases, schemas, and tables can be slower than the actual query execution.
- Check whether the issue occurs across different networks or machines to rule out a client-specific or network-specific problem
Thanks,
Chaithanya.
- 2 months ago
Hello community,
Thank you all.
The issue was not resolved, but probably as most of you said, It could be a Network (VPN) issue.
Thank you.
Hi PBI_2K26
In most cases, slow performance comes from Direct Query or query folding issue. Even small tables can feel slow because each visual sends multiple queries back to Snowflake. Make sure you are using latest Snowflake Connector rather than older ODBC driver. Check query folding if transformations don’t fold as Power BI pulls more data than needed. Try simplifying visuals and DAX logic. Reduce number of visuals per page. If real time is not critical you can use Import instead Direct Query