Forum Discussion
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 passwo...
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!