Snowflake Key Pair Authentication

Hi Fanz  ,

As per official Microsoft Fabric documentation, the private key should always be provided in the full PEM format, including the complete header and footer lines such as ----BEGIN PRIVATE KEY---- and ----END PRIVATE KEY----, or the encrypted version if necessary. In Power BI Desktop, you need to paste the entire key content including these headers and footers in the key field. In Power BI Service (app.powerbi.com), you should upload the private key file itself, and that file must also contain the full key with headers and footers. If your key is encrypted, then you also have to provide the passphrase. So basically, the key should always be complete, and the only difference is that in Desktop you paste the full key, whereas in Service you upload the full key file.

Refer these Microsoft official Docs -
Microsoft Fabric – Snowflake connector (Key-pair authentication):

https://learn.microsoft.com/en-us/fabric/data-factory/connector-snowflake

Power BI – Connect to Snowflake :
https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake

These documents confirm that the private key must be in full PEM format and explain how the connector expects the key to be provided.

Thank you.