Tableau Desktop cannot establish a connection
Problem
When you try to connect Tableau Desktop to Data Connect, you see the following error:
Cannot load data into PowerBI. Receiving an HY000 [Microsoft][Snowflake] (25) message
Cause
This error is caused by a proxy setting on your local machine that prevents data from being loaded from Data Connect.
Data Connect is provided through third-party Snowflake cloud services. Tableau requires networking opened up to communicate with Snowflake.
Solution
You can try the following to resolve this problem:
-
Troubleshoot by disabling your security tool: Turn off your security tool, like Zscaler or Cisco, to see if it resolves the connectivity issue. If this resolves the connection issue, make sure that your security tool is upgraded to the latest version, add the Data Connect (Snowflake) IP address to the VPN allowlist with your internal network team.
-
Add IP Addresses to Allowlist: Ensure that your firewall settings allow the IP addresses used by Data Connect. Use the command
SYSTEM$ALLOWLIST()to obtain the IP address, which you can then allowlist in the VPN. -
Check firewall and Proxy Settings: Check if any firewall or proxy configurations on your network are blocking access to Snowflake’s endpoints. You might need to contact your network administrator to add the required Snowflake IP addresses and ports to your company’s allowlist.
-
Workaround option: Create an extract from a worksheet screen instead of the Data Source pane in Tableau. The connection doesn’t get lost and the extract process completes.