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.

arinjayjain1013's avatar
arinjayjain1013
Frequent Visitor
8 months ago

Hi everyone, 

I noticed for snowflake connector in Power BI, I see a 3rd option for KeyPair authentication. Wanted to check if it in preview mode or open for all, as I do not see a official message from Power BI. Any updates regarding the same will be helpful.
If you have any official communication, please share the link.

 

diabb8899's avatar
diabb8899
Frequent Visitor
8 months ago

Hi arinjayjain1013 ,

I supposed it has been quietly released in Sep but they have not updated the Roadmap tracker's status yet.

 

Fabric GPS - Microsoft Fabric Roadmap Tracker

I would caution that you test it in your non-prod env first before doing the transition to your prod env.

The keypair auth seems to consume more resources (CPU and memory) than the normal username / password auth method and if your job is complex , it will fail.