Forum Discussion

gmvinfopro's avatar
gmvinfopro
New Member
10 months ago
Solved

Snowflake connector 2.0 : Slow performence analyses

Hi Yesterday I forced the direct query model to use the latest version of the connectors Following the tests with the new connectors, I did not notice any improvement and even a degradati...
Need Help
Show and Tell
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    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

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
10 months ago

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

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
10 months ago

Hi gmvinfopro ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi @gmvinfopro ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

     

    Regards,

    Dinesh