Snowflake Connector - An existing connection was forcibly closed by the remote host

[stefanjt]

Hi, community. I need your help with something that I've been struggling with for a few weeks now.

When we try to load data from Snowflake (26 million rows) into PBI by using the Snowflake connector, we are getting an error, "An existing connection was forcibly closed by the remote host". Attached is the error message. 

We already tried various things to load that data from Snowflake (including deleting cache, installing the latest driver from Snowflake, increasing timeout times, using the legacy SF driver, etc.) to no avail. The error message appears consistently around after 5-6 million rows have been loaded. The queries in Snowflake appear as having succeeded, which most probably means that there is some communication issue between Snowflake and PBI. 

We reached out to Snowflake's support and they told us looking at the logs, it appears that the issue comes from the ADBC driver implementation that the September release of PBI is using. Using the legacy Snowlfake driver

still produces an error indicating that it's using ADBC.

[rajendraongole1]

Hi  @stefanjt  -  can you try with downgrade the version,Revert to a version prior to the ADBC switch — for example:

Power BI Desktop August 2024 or July 2024 . You can download older builds from:

https://learn.microsoft.com/power-bi/fundamentals/desktop-latest-update-archive

This ensures the legacy ODBC Snowflake driver is used natively.

ODBC Driver | Snowflake Documentation

Power BI SSO to Snowflake | Snowflake Documentation

Hope this helps. 

@stefanjt

[stefanjt · Accepted solution]

Hi, community. I found the fix.

When you go to Options - Preview features - select Use legacy Snowflake connector implementation - restart PBI, this changes the connector for data sources that you add after this point.

To switch to the legacy connector for already added data sources, you need to go to Power Query and change the Implementation from 2.0 to 1.0 in the very first step:

This then uses the ODBC driver, which manages to load vast amounts of data (unlike ADBC).

[stefanjt]

Thanks for the suggestion! I'm using PBI from Microsoft Store and exe installations are generally restricted as I'm using a company PC. Is it possible to resolve it some other way? I thought using the legacy driver (from Preview features) would be ODBC?