Forum Discussion
Snowflake Connection to Power Bi Desktop Error
Hi Team, I trying to connect to Power Bi and Snowflake, but it is giving me this error,
But I dont have any option to provide AUTH Code, can you please help me with this.
Thanks
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.
6 Replies
Hi SainathKrothap ,
That error means the Snowflake account you’re connecting to requires MFA with TOTP (the one‑time code from your authenticator). Power BI’s Snowflake connector doesn’t prompt for or accept a TOTP code, so you can’t complete the login with the default username/password flow when MFA is enforced by the IdP.
You’ll need to use an authentication method that doesn’t require a TOTP code, or get MFA disabled for that specific BI connection.
Use a non‑MFA authentication path for BI
Key pair authentication (RSA) for SnowflakeWhy: No TOTP needed. You authenticate with a private key instead of a password.
How (high level):
Generate an RSA key pair (private key and public key).
In Snowflake, upload the public key to the BI user (ALTER USER BI_USER SET RSA_PUBLIC_KEY = '-----BEGIN PUBLIC KEY-----...').Please mark this post as solution if it helps you. Appreciate Kudos.
hello SainathKrothap
seems you are using an auntentication type that requires a password.
try to tap that edit button, perhaps it shows where to put in your authentication code.
if there is no field for code, try clearing permission in data source setting.
Thank you.
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.
Hi SainathKrothap ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Hi SainathKrothap ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
