Forum Discussion
Snowflake cloud connection: KeyPair authentication
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.
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
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.
Hi diabb8899,
We are not using gateway to access Snowflake. We are utilizing Cloud connection(s) defined/created withing Power BI service, and using user/password with PAC (Programming Access Token) authentication.
Also, I did perform another round of tests playing with Implementation 1/2 in Power BI. What I discovered is: models with either implementation (1 or 2) did not refresh under user with Keypair authentication. However, connection with a user under PAT authentication worked just fine with both implementation versions.
Microsoft announced GA for Snowflake Keypair authentication. Perhaps it's time for another support ticket?
Best Regards,
Sam