cancel
Showing results for 
Search instead for 
Did you mean: 

Snowflake MFA token caching not working

If I connect to Snowflake as per https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake  

(using Snowflake as my IDp - without Microsoft AAD integration), and MFA token caching is enabled https://docs.snowflake.com/en/user-guide/security-mfa.html#label-mfa-token-caching  

 

ALLOW_CLIENT_MFA_CACHING  = true

ALLOW_ID_TOKEN  = true

 

I get 2 DUO push notifications for each dataset connected to PowerBI, each time the dataset is refreshed. MFA Tokens are not cached.

 

Due to delays or missing push notifications, the Snowflake account gets locked.

 

I have tested the Windows ODBC driver with the following authenticator option in a new DSN and it caches tokens perfectly:

https://docs.snowflake.com/en/user-guide/odbc-parameters.html#additional-connection-parameters  

authenticator=username_password_mfa

 

However it doesn't seem to work in the Simba Snowflake ODBC driver that is natively installed in PowerBI:

C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Snowflake ODBC Driver

even if I add it to a microsoft.snowflakeodbc.ini file:

[Driver]
authenticator=username_password_mfa

Status: Investigating

Hi, 

If you want to get a solution for this kind of connection problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

Hi, 

If you want to get a solution for this kind of connection problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

mbreeze
New Member

Done - I've raised a support ticket. 

v-robertq-msft
Community Support

OK, thanks for the response!