Snowflake Key Pair Authentication

[Fanz]

Hi there,

I am looking for some type of resource/guidance/ documentation in setting up a Snowflake Key Pair using the native snowflake connector > KeyPair option. I wold like to to this for both Desktop as well as Power BI Service but I am having trouble finding doccumentation on how to properly set this up. Can you please point me to the documentation?

[v-tsaipranay]

Hi @Fanz ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @Fanz ,

Thank you for reaching out to the Microsoft Fabric Community Forum. 

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by @Ritaf1983 . If you still require support, please let us know, we are happy to assist you.

Thank you.

[Ritaf1983 · Accepted solution]

Hi @Fanz 

To set up Snowflake Key Pair authentication using the native connector in Power BI (Desktop and Service), follow these steps based on current implementation standards:

1. Snowflake Configuration
Generate a 2048-bit RSA key pair and assign the public key to your Snowflake user.

Command to set the public key in Snowflake:

SQL

ALTER USER <username> SET RSA_PUBLIC_KEY='<MIIBIjANBg...>';
Note: Ensure you remove the "---BEGIN PUBLIC KEY---" and "---END PUBLIC KEY---" headers/footers and any line breaks when pasting the key into Snowflake.

2. Power BI Desktop Setup
The native Snowflake connector now includes a specific KeyPair tab in the authentication dialog.

Select Get Data > Snowflake.

Enter your Server and Warehouse.

In the authentication window, select KeyPair from the left-side menu.

Private Key Path: Provide the local file path to your private key file (e.g., C:\Keys\snowflake_key.p8).

Passphrase: Enter the password used to encrypt the private key.

3. Power BI Service Setup
After publishing the report, you must configure the credentials in the cloud environment.

Go to the Workspace and locate the Semantic Model.

Open Settings > Data source credentials > Edit credentials.

Set the Authentication Method to KeyPair.

Private Key: Instead of a file path, you must paste the entire content of your private key file (including the BEGIN/END headers).

Passphrase: Enter the associated password.

Note: If using an On-premises data gateway, ensure it is updated to the latest version to support the ADBC-based Snowflake connector.

Official Documentation
Snowflake Key-Pair Authentication: https://docs.snowflake.com/en/user-guide/key-pair-auth

Power BI Snowflake Connector: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Fanz]

Thank you so very much for the detailed information. When trying to implement hit some issues internally and haven't yet been able to test end to end but provided the detail and documentation this should be sufficient. I appreicate the time you took to share. This is exactly what I was looking for.