Snowflake - ODBC Error Invalid OAuth Token

[Anonymous]

Hello! A user in my organization is getting the following error when trying to connect to Snowflake using the built in Snowflake connector in Power BI Desktop:

ODBC Error [28000] Invalid OAuth access token

I have mirroed her exact Snowflake permissions and I am able to connect without any issues. Another user in her group is also able to connect successfully. I have confirmed she has the July 2020 version of Power BI Desktop (same version as me). 

Has anyone seen this error before? Does anyone have any suggestions? 

Thank you!

[Anonymous · Accepted solution]

Hi everyone - thank you all for your suggestions. The solution ended up being a simple Power BI desktop update! Once the user updated her version of Power BI, she was able to connect to Snowflake successfully. 

[v-alq-msft]

Hi, @Anonymous 

I wonder if you sign in with 'Snowflake' or 'Microsoft Account'. If you put in your username and password for a particular Snowflake server, Power BI Desktop uses those same credentials in subsequent connection attempts. If you want to use the Microsoft account option, the Snowflake AAD integration must be configured on the Snowflake side. Please Verify that the external_oauth_issuer parameter contains the correct value. In Azure AD, verify the access token is current.

For further information, please refer to the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

refer if these can help

https://www.snowflake.com/blog/using-sso-between-power-bi-and-snowflake/

https://support.snowflake.net/s/article/Invalid-OAuth-access-token-while-connecting-to-Snowflake-from-snowsql-using-external-OAuth