Forum Discussion
Snowflake - ODBC Error Invalid OAuth Token
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!
3 Replies
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_issuerparameter 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.
