Error when loading mirrored Snowflake database using Key-pair Authentication: "The length 34 has exceeded the limit of 31."

Question

I am using PowerBI services on Azure and a mirrored connection to Snowflake. I just switched to using Key-pair Authentication in PowerBI for the mirrored Snowflake database connection. Now, I get an error: "The length 34 has exceeded the limit of 31." for most of my databases when loading them. This used to work fine when I was using password authentication as I was under the Snowflake limit of 35 for the database name.

---

Moderator: Moved from SQL Server Database Engine

Answer 1

You have posted this question to the Microsoft Q&A forum using the tag SQL Server Database Engine (which I will change).

Snowflake is not a Microsoft product at all, and for Snowflake questions you will need to find a Snowflake forum.

PowerBI is indeed a Microsoft product, but it is not covered in Microsoft Q&A. A good place to ask PowerBI questions is https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

Answer 2

The error message "The length 34 has exceeded the limit of 31" suggests that there is a limitation being enforced on the database name length when using Key-pair Authentication in Power BI for your Snowflake connection. While Snowflake allows database names up to 35 characters with password authentication, it appears that the Key-pair Authentication method may impose stricter limits, potentially due to how the connection is being handled or configured in Power BI.

To resolve this issue, you may want to consider renaming your databases to ensure that they comply with the 31-character limit when using Key-pair Authentication. Additionally, reviewing the configuration settings in Power BI for the Snowflake connection could provide insights into any specific limitations or requirements that need to be addressed.

If you continue to experience issues, consulting the Snowflake documentation or reaching out to their support may also be beneficial for understanding the constraints associated with Key-pair Authentication in your specific setup.

---

References:

• Authentication
• I'm using Snowflake with key-pair authentication. How can I configure Azure Analysis Services server to use it?