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
9 months ago

Hi diabb8899,

Same story here, waiting on support. I have a ticket open, which has been escalated already.

Regarding connector, I did try both options mplementation options, but no success.

diabb8899's avatar
diabb8899
Frequent Visitor
9 months ago

Hi ustas55 , 

 

yeah... I guess we have no choice but wait for the support to provide a resolution on this.

I have suggested to them if they can downgrade to Implemention 1.0 for the keypair auth since that is the working implementation that runs with the username and password.