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:
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:
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.
Thank you very much!
Community Support Team _Robert Qin
Done - I've raised a support ticket.
OK, thanks for the response!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.