Snowflake connector 2.0 : Slow performence analyses

Hi gmvinfopro ,

Thank you for reaching out to the Microsoft Community Forum.

Hi lbendlin , thank you for your prompt response.

Hi gmvinfopro ,

For V2 Connector Excessive metadata calls like SHOW PARAMETERS, SHOW COLUMNS, SHOW PRIMARY KEYS for every visualization element. This leads to hundreds or thousands of extra requests, creating latency and poor user experience in Power BI.

Please try below things to fix the issue.

1. Some versions allow disabling metadata checks or enabling caching. Look for options like "EnableMetadataCaching " or similar in the connector or Power BI settings.

2. Please check if metadata calls happen per visual or per query refresh.

Please refer below link.

Power Query Snowflake connector - Power Query | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh