Snowflake Connection to Power Bi Desktop Error

Hi SainathKrothap ,
The error is occurring because the Snowflake connector in Power BI Desktop does not support MFA or TOTP authentication codes, such as those from Google Authenticator. As a result, there is no option to enter an authentication code in the connector.

To address this, you can consider the following options:

Option 1 – Key-Pair Authentication (Recommended):

Generate an RSA key pair on your device.

Upload the public key to your Snowflake user profile using the appropriate SQL command.

In Power BI, connect to Snowflake and select Key-Pair Authentication.

Enter your private key and password.

Option 2 – SSO via Azure AD or Okta:
If your Snowflake environment is federated with Azure AD or Okta, you can connect using SSO. Power BI will redirect you to your organization’s login page, where MFA is managed automatically.

Option 3 – Service Account Without MFA:
You may request your Snowflake administrator to create a technical account without MFA specifically for BI or reporting purposes. You can then use the standard username and password credentials in Power BI, if permitted by your organization’s security policy.

In summary, Power BI does not support direct MFA code entry, so one of these alternative authentication methods will be required to connect successfully.