Unable to connect to Snowflake for newly created MFA enabled User

[_mrugesh]

I created a new user in Snowflake (auto MFA enabled). I can log in via browser using SSO, but when I am trying to log in via Power BI using the default Snowflake connector, it is throwing the following error:

Please suggget me the solution.

[v-priyankata]

Hi @_mrugesh 

Thank you for reaching out to the Microsoft Fabric Forum Community.

Whatever suggested by @collinq is correct. @collinq Thank you for your inputs.
@_mrugesh - Check that the new user has the right roles and permissions in Snowflake. please find below microsoft documents, these may help you.
Power Query Snowflake connector - Power Query | Microsoft Learn
Connect to Snowflake with Power BI - Power BI | Microsoft Learn
Set up your Snowflake database connection - Microsoft Fabric | Microsoft Learn

If this information is helpful, please “Accept as solution” to assist other community members in resolving similar issues more efficiently.
Thank you.

[collinq]

Hi @_mrugesh ,

If this is MFA enabled it won't be easy to use in the Service.  There are ways around it but they are mostly manual.  THe big issue is that Power BI Service does not use interactive logins - and MFA is interactive.  So, Power BI sees if it has access or not and if it has to wait for an MFA to be entered, it fails.  The common workaround is to use a service account that is not MFA and use the Service Account for the Data Source and then there is no MFA issue.