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.

ustas55's avatar
ustas55
Helper II
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,

Thank you for the update as your issue got resolved.