Forum Discussion
Power BI desktop Snowflake ODBC driver connection problem
Had this same issue last year when I updated to the June 24 version but got solved with the October 24 version.
Now I am having the same issue after updating to the August 25 version!! Such a pain. Can microsoft please correct this?
I don't think you are having the same issue as it has been patched.
what i would advise is to check the new version of the ADBC connector which is known to cause issues.
you can either add a no_proxy rule to your environment variables depending on your datasource
OR use the old odbc connector by removing the implementation=2.0 part in the advanced editor in your data transformation tab.
jmweekesAdvocate II
I feel your pain, nickgcraw.
Thank you for this information, BBouwman0820. You can also uncheck "Use new Snowflake connector implementation" in the Preview features in order to use the old ODBC connector. We discovered that this was necessary in order to see database views when selecting "tables" in Power Query/Transform.
Do you have any more information on the specifics of the no_proxy rule?
hi jmweekes,
Make sure you have updated to the last version of Power BI desktop, unchecking the preview feature is not in the last version anymore. If you do have an older version it might be a suitable option to uncheck it.
if you are using a newer version the 'views' problem should be fixed.
however, because you can not just disable the preview feature, you will have to delete the piece of text that determines if you are using the ODBC or ADBC version. this can be doen in the advanced editor in power query editor.
if you still experience a problem then, you can add a new line to your environment variables but that could cause other issues.
name; NO_PROXY
value; .amazonaws.com,.azure.com,.gcs.com,localhost,127.0.0.