Want to use key pair authentication access from Power BI to Snowflake.

[satoshi_shinoda]

With a recent update, Azure Data Factory now supports key pair authentication to Snowflake. I would like to unify the authentication method, so I would like Power BI and the on-premises data gateway to support key pair authentication as well.

[jikuja]

https://docs.snowflake.com/en/user-guide/programmatic-access-tokens

Few notes:

• * for service account PATs there must be network policy assined to service user
• * for service account PATs "ALTER USER … ADD PROGRAMMATIC ACCESS TOKEN" command must include ROLE_RESTRICTION
• * user creating PAT for service user must own service user or have a grant for PATs
• * If you want to create new self PAT with service user grant must be added
  • * at least for "ALTER USER … ADD PROGRAMMATIC ACCESS TOKEN" not sure about rotation

[rgc954]

+1 While PATs are a good alternative for some, key-pair authentication will still be required moving forward once Snowflake closes its doors on legacy_service users. For some a PAT may suffice, for others it may not.

[uadrian92]

Any word on this from Microsoft anywhere? Time is nigh.

[jeromelam]

The roadmap item under "Data Factory" titled "Connectors - Snowflake Key-Pair Auth type" has been completely removed. It's not under "preview" or "released" either. However, I did notice that in the latest version of Power BI Desktop (Sept 2025), there's now a 3rd authentication method called "KeyPair". This is not available on Power BI Service yet. @uadrian92, are you seeing the same thing?

[uadrian92]

@jeromelam Yea, you are right, I do see the option and it is working just fine. I thought I already installed the latest PBI version but it turns it I did not, my bad 🙂 Thanks!

[msaunier]

Hello,

Indeed, updating the authentication to key pair does not allow refreshes via the Power BI cloud interface, which returns the message: "The credentials provided for the Snowflake source are invalid." However, data refresh via the Desktop application works correctly. Should I submit a bug report, or do we have confirmation that this will be deployed soon, before November and the update to Snowflake's security policies?

Thanks.

[jeromelam]

@msaunier, with November coming up quick, it would help to have a bug submitted. I haven't found any confirmation this is being handled in parallel with the changes made to Desktop.

[Toanphung]

Interested as a snowflake/Fabric user

[kelly646466]

I am not seeing this new feature listed in the September 2025 release notes. I am still on the August 2025 version and was just upgraded so I fear my firm will not be ready to upgrade to the September 2025 version anytime soon. Why did Microsoft wait so long to release this? Snowflake has been prepping for this for MONTHS.

[msaunier]

@Toanphung I have sent a message to support and am waiting for their response. I will share any important information regarding this issue with you.