Forum Discussion

pragyajains's avatar
pragyajains
New Member
1 year ago
Solved

Unable to connect to Snowflake

I am unable to connect to PowerBI. Tried everything possible, reset connection, uninstall, repair ODBC, check proxy, test DSN, nothing worked. Please help.

  • Hi pragyajains 


    You're getting a 502 Bad Gateway error from Snowflake when trying to connect via the ADBC driver. This usually points to a network issue, especially if you're using a PrivateLink endpoint (as in your case).

    Here are a few things to check:

    Network and DNS access
    Make sure you're connected to the org network (VPN / Direct Connect) and that DNS can resolve *.privatelink.snowflakecomputing.com. Also verify firewall or proxy settings with IT.

    Try connecting via the public Snowflake URL
    Use the regular Snowflake URL instead of PrivateLink, just to isolate the issue.

    Check your role and warehouse
    Make sure the role and warehouse in the error string actually exist and you have access to them.

    Driver version
    Confirm that the ADBC / ODBC driver matches your Power BI version (32/64 bit), and that it's installed correctly.

    Try connecting via SnowSQL / another client
    That can help determine whether the issue is with Snowflake or Power BI.

    If nothing works, I suggest opening a ticket with Snowflake Support. Include the full error, your region, and confirm whether you're using PrivateLink.

    Support: https://support.snowflake.com

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

  • Thank you!

     

    I did not have my "no_proxy" set. Once I set my proxy, it connected to snowflake. Thank you so much 🙂 

4 Replies

  • Hi pragyajains 


    You're getting a 502 Bad Gateway error from Snowflake when trying to connect via the ADBC driver. This usually points to a network issue, especially if you're using a PrivateLink endpoint (as in your case).

    Here are a few things to check:

    Network and DNS access
    Make sure you're connected to the org network (VPN / Direct Connect) and that DNS can resolve *.privatelink.snowflakecomputing.com. Also verify firewall or proxy settings with IT.

    Try connecting via the public Snowflake URL
    Use the regular Snowflake URL instead of PrivateLink, just to isolate the issue.

    Check your role and warehouse
    Make sure the role and warehouse in the error string actually exist and you have access to them.

    Driver version
    Confirm that the ADBC / ODBC driver matches your Power BI version (32/64 bit), and that it's installed correctly.

    Try connecting via SnowSQL / another client
    That can help determine whether the issue is with Snowflake or Power BI.

    If nothing works, I suggest opening a ticket with Snowflake Support. Include the full error, your region, and confirm whether you're using PrivateLink.

    Support: https://support.snowflake.com

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

    • pragyajains's avatar
      pragyajains
      New Member

      Thank you!

       

      I did not have my "no_proxy" set. Once I set my proxy, it connected to snowflake. Thank you so much 🙂 

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hello pragyajains 

        We appreciate your efforts and are pleased to hear that your issue was resolved. thanaks Ritaf1983  for you inputs. pragyajains Please mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

         

        Thank you.