vertical

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!!!!

Hi Anonymous,

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

Regards