Forum Discussion
SSH Key Pair Authentication - Snowflake
Hi kevinconseil ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Power BI's Snowflake connector doesn't support SSH or key pair authentication, which is becoming more important for secure service accounts.Using a middleware like Azure Functions or an API Gateway is a valid workaround. It can connect to Snowflake securely using the key pair and then expose the data to Power BI through REST or OData. It adds some complexity but helps stay compliant.
We highly value your feedback on this feature and encourage you to share your thoughts through the Fabric Ideas forum to help shape future improvements:
https://ideas.fabric.microsoft.com/Please let us know if you need any further clarification or support. We appreciate your engagement in the Microsoft Fabric community!
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
I raised a feature request for this with Snowflake about a month ago. Even better would be if it was possible to use a managed identity for Power BI to connect to the datasource, although you'd have to control permissions with a very clear & deliberate design in mind. With key-pair auth you can at least have different logins for each use case and restrict permissions appropriately.
... I'm assuming that it's Snowflake rather than Microsoft that build the connector.