Forum Discussion
Snowflake Data Source Will Require Key-Pair Authentication - Connector Update Inquiry
Hi kathybootsri,
Thank you for your response. We understand that you're looking for confirmation on whether key-pair authentication will be supported in the Snowflake connector for Power BI.Currently, there is no official confirmation from Microsoft regarding this feature. However, we recommend:
- Voting on the existing Idea request for key-pair authentication in the Microsoft Fabric Ideas forum: Want to use key pair authentication access from Po... - Microsoft Fabric Community More votes increase visibility and the chances of this feature being prioritized.
- Keep an eye on for any official announcements: What's New? - Microsoft Fabric | Microsoft Learn
If you find this information useful, please “Accept it as a solution” and give it a “Kudos” to assist others in locating it easily.
Thank you.- Voting on the existing Idea request for key-pair authentication in the Microsoft Fabric Ideas forum: Want to use key pair authentication access from Po... - Microsoft Fabric Community More votes increase visibility and the chances of this feature being prioritized.
Just to say that an alternative is to use a PAT token. This can be done for a Snowflake SERVICE login, and works for PowerBI connections. I've just been testing it and it works a treat.
The (arguably) drawback is that the token has an expiry date of a maximum of 12months, so any connections will need updating at least every 12months.
I say "arguably", because forcing a token expiry is a little more secure than depending on a private key.
https://docs.snowflake.com/en/user-guide/programmatic-access-tokens
Even better would be the ability to use a workspace scoped managed identity. I assume that will come along in the future.