Forum Discussion

kevinconseil's avatar
kevinconseil
Advocate II
1 year ago
Solved

SSH Key Pair Authentication - Snowflake

Hi Everyone, Snowflake rolled out a new security measure that all SERVICE users should connect to snowlake using SSH Key Pair Authentication.  I see that PowerBI does not offer the possibility ...
Need Help
  • v-menakakota's avatar
    v-menakakota
    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.

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi kevinconseil 

Power BI’s Snowflake connector doesn’t currently support SSH key pair authentication, which is increasingly important for secure service account access.

A practical workaround is to use a proxy or middleware layer for example, Azure Functions or an API gateway that connects to Snowflake using the SSH key, then exposes the data via a Power BI–friendly format like REST or OData. This adds some architecture overhead but keeps you aligned with Snowflake’s new security policies.