Skip to main content
Question

Issue with Vertica native Power BI Connector

  • March 24, 2023
  • 1 reply
  • 7 views

jaydens

It looks like there is an issue with the Power BI Vertica Connector.

We are able to connect to Vertica using ODBC in Power BI. However, on the same machines, we're not able to using when using the native connector in Power BI. We get the following error:

"ODBC: ERROR [08001] [Vertica][VerticaDSII] (160) Connection attempt
failed: could not send SSL negotiation packet: Socket is not connected
(0x00002749/10057)

This presents a problem, because we need to use the native connector, so we can take advantage of DirectQuery (ODBC is import only).

We are on Vertica version v10.1.1-14. This occurs for all of our machines.

1 reply

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • March 24, 2023

Please open a support case if possible. If not, let us know more details, such as where Vertica is deployed and whether connection load balancing is enabled on client or server settings.