Forum Discussion

ustas55's avatar
ustas55
Helper II
9 months ago
Solved

Snowflake cloud connection: KeyPair authentication

Good Day Professionals,   We have a cloud connection to the Snowflake and successfully used it with "regular" authentication via user/password. The Snowflake user was configured as SYSTEM account w...
Need Help
  • ustas55's avatar
    ustas55
    8 months ago

    Hi to all,

    Quick update on this issue (Key-Pair authentication between Snowflake and Power BI).

    Finally got a “solution” from the support and was able refresh the model using Key-Pair authentication.

    What I ended up doing is to enable “Use legacy Snowflake connector implementation” within Preview features.

    According to Microsoft support: “Currently, Implementation 2.0 consumes more memory, which the engineering team is actively working to optimize. This issue has been documented in the reference document below, and the document will be updated once the fix is implemented and released”.

     

    Thank you.

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
8 months ago

Hi ustas55,

Could you please confirm if the issue has been resolved after raising the support ticket?

 

Thank you.

ustas55's avatar
ustas55
Helper II
8 months ago

Hi,

Unfortunatelly, not yet. Support is still woring on my ticket, and I was told that ".... we're still waiting an update from our team.".....

  • diabb8899's avatar
    diabb8899
    Frequent Visitor
    5 months ago

    Hi ustas55 , any update from MS support on the issue? they release the update in Feb , did it help resolve ? or you are still having memory issues.

    • ustas55's avatar
      ustas55
      Helper II
      5 months ago

      Hi diabb8899, I wasn't aware of any updates with this connector, so for now we're using a user with PAT authentication. Actually, few days ago I did check documentation on Snowflake connector and didn't see any changes with known issues; same high memory utilization when using Implementation-2 option.

       

      Best Regards,

      Sam

      • diabb8899's avatar
        diabb8899
        Frequent Visitor
        5 months ago

        Hi Sam (@ustas55),

        Thanks for the update. I was informed by Microsoft Support that the issue was supposedly fixed in the February data gateway release (version 3000.302.6). However, after installing and testing this in my development environment, I’m still seeing high memory utilization when using Implementation 2.0 (ADBC). The same behaviour occurs even when using username/password authentication with Implementation 2.0.

         

        I wanted to check whether you’re experiencing the same issue on your end. If you do test it, I’d recommend doing so in a separate environment where you can easily roll back to the previous version.

         

        Microsoft Support also mentioned that Implementation 1.0 (ODBC) will no longer be supported and is expected to be deprecated around mid‑2026. This is a concern, as it may remove the last known working option (even when using Snowflake PAT).

        Let me know your findings.

         

        Thanks.