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.

anilgavhane's avatar
anilgavhane
Super User
9 months ago

ustas55 

KeyPair authentication for Snowflake is supported in Power BI, but it may behave differently than PAT. The memory error likely stems from query execution context or resource settings under the KeyPair identity.

Quick Fixes:

  • Compare session parameters between PAT and KeyPair logins.
  • Check Snowflake warehouse size and scaling policies.
  • Use logging to inspect query performance.
  • Ensure private key format and JWT setup are correct.

Let me know if you want help testing with smaller queries or reviewing session settings.

ustas55's avatar
ustas55
Helper II
9 months ago

Hi Anil,

Both account (PAT and KeyPair) have identical security profiles, assigned to the same withing the Snowflake, so the Warehouse size and/or session/query parameters (in my opinion) should be the same.