Forum Discussion

Gangadhar09's avatar
Gangadhar09
Regular Visitor
1 year ago

Assistance Required for Connecting Power BI to Snowflake Using Keypair Authentication

Dear Team,

I hope this message finds you well.

I am currently working on connecting Power BI to Snowflake, and I would like to use keypair authentication instead of the standard username and password method. However, I am encountering difficulties in establishing the connection using keypair authentication.

Could you please assist me in setting up the connection with the necessary steps or troubleshooting tips? Any guidance or insights would be greatly appreciated.

Thank you for your time and support.

Best regards,
Gangadhar

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Gangadhar09 ,

     

    Connecting Power BI to Snowflake using keypair authentication involves the following steps.

     

    • First, you generate a private key using OpenSSL, at which point you can choose to generate an encrypted or unencrypted private key.
    • Then, on the command line, generate the public key by referencing the private key.
    • Execute the ALTER USER command to assign the public key to the Snowflake user.
    • Then use the Snowflake ODBC driver to set up an ODBC data source for Snowflake. In the ODBC Data Source Manager, configure the DSN with the necessary connection details.
    • Open Power BI Desktop.
    • Select Get Data and then select ODBC.
    • Select the DSN you configured for Snowflake.
    • In Connection Settings, select Key Pair Authentication and enter the relevant information.

     

    More detailed step-by-step information is available:

    Key-pair authentication and key-pair rotation | Snowflake Documentation

     

    For related troubleshooting check out this documentation:

    https://docs.snowflake.com/en/user-guide/key-pair-auth-troubleshooting

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • Gangadhar09's avatar
    Gangadhar09
    Regular Visitor
    1 year ago

    Hi Yang,

    Thanks for your reply, while configuring odbc driver, we need to enter the username and password mandatory, but with keypair authentication we do not have any password, we do have only username

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Gangadhar09 ,

     

    You can choose to generate an encrypted version or an unencrypted version when generating a private key, they have different commands, please make sure you are generating an encrypted version:

     

    Detailed steps for connecting to Snowflake using key pair authentication in the ODBC driver can be found in the documentation below:

    ODBC configuration and connection parameters | Snowflake Documentation

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!