Forum Discussion
SSH Key Pair Authentication - Snowflake
- 1 year ago
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.
kevinconseil : FYI: Snowflake released PAT (programmatic-access-tokens). One of our developers implemented it yesterday and it works perfectly for our service accounts. https://docs.snowflake.com/en/user-guide/programmatic-access-tokens
- kevinconseil1 year agoAdvocate II
Starriver Would you mind sharing the method on how to do this ? I just spent half a day with chat gpt and snowflake documentation without any success.