vertical

[Anonymous]

Hi,

In recent build of Power BI, Option for connecting with Vertica is introduced. Problem that I am facing is that I am not getting an option for providing port on which my DB is running. What is the way of providing the port of DB if DB is not running on Port 5443.

Thanks!!!!

[v-ljerr-msft]

Hi @Anonymous,

Could you try using sql server ip address, port number as the server name to see if it works? 

Regards

[Anonymous]

Vertica option is specifically meant for connecting Power BI with Vertica. I doubt SQL will work with Vertica DSN.

It seems to me Power BI only supports with deafult Port while connecting Vertica.

[Anonymous · Accepted solution]

I found the solution. Vertica for now is not going to work on Port other than 5433.

[Anonymous]

Hi,

In recent build of Power BI, Option for connecting with Vertica is introduced. Problem that I am facing is that I am not getting an option for providing port on which my DB is running. What is the way of providing the port of DB if DB is not running on Port 5443.

Steps:

1) Open Power BI Version >> 2.51.4885 (October 2017)

2) Click on "Get Data" for making the connection.

3) On Get Data window, under "Other" tab, select option "Vertica (Beta)". This option is introduced in latest release.

4) Click on Connect Button.

5) On the screen, Port option is missing.

Problem: My DB is not running on default port (i.e. 5443) therefore I am unable to connect with my DB. Below is the attached screenshot.

 

Please help.

Thanks!!!!