Forum Discussion
Access to Snowflake via key pair authentication
Hi bergen288,
Thank you for reaching out to Microsoft Fabric Community Forum.
Currently, Power BI does not support key-pair authentication with Snowflake. Please follow below step:Please submit a feature request to Microsoft through their Power BI Ideas platform. Before submitting, search to ensure the idea doesn't already exist, or upvote it if it does.
https://ideas.fabric.microsoft.com/
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hey there bergen288 .. One option you can use to get you by is a Snowflake access token (similar to a personal access token) in place of a password. With all of the authentication changes to Snowflake including introduction of user types, restrictions on users w/o MFA, Power BI badly needs key pair authentication.
To get you by, for your existing service user in Snowflkae you can generate an access token now and use that in place of the password.
Just be mindful of that token refresh interval. Becuase there is no concept of key vault and automated rotation like Azure or AWS. I have put Snowflake into our key rotation schedule until the authentication and access story plays out.