Power BI Desktop Snowflake Refresh Fails: “Cannot Convert Null to Text” While Service Still Works

Hi everyone. My team has been in touch with Microsoft. They are actively looking into the issue and anticipate a fix for the July release.

For now, those using Snowflake + KPA and are hitting this error upon local refresh: Try editing your KPA credentials and for the passphrase (which is technically optional), put any string - I put 'test'. It should succeed in connecting. It is not a long-term sustainable solution but it is a recognized workaround.

Per Microsoft (also posted in this forum): "This is because when the user does not provide a passphrase for the certificate (the field is optional and only needed for encrypted PKCS#8 keys), the value is null, and the ADBC Snowflake driver fails rather than treating the key as unencrypted. There fix is fix for the July release. The workaround is to provide optional passphrase to an empty string before passing it to the driver."