Issue with Postgreys database connection.

[Abd]

Hi there,

I am trying to connect to Postgreys Database, I have provided Server & database details but I am keep getting timeout issues.

Upon detail analysis I found that there are 2 ports one (123) is restricted & another one (456) is open so I think its hitting restricted one; so how can hit to open port (456).

Regards,

Abd

[v-angzheng-msft]

Hi, @Abd 

You could reference the ways to change timeout parameters to check if you could connect the data source without an error. 

1. Add timeout parameter to connection string:

• Connect Timeout=xx  (xx = seconds)

2. Otherwise, you could add  timeout parameter to Query argument within M Code / Advanced Editor:

• let
  Source =
  Odbc.DataSource(
  xxxxxxxxxxxxxxxxx,
  [Query = "xxxxxxxxx",CommandTimeout =#duration(0,1,0,0)]
  )
  in
  Source 

ConnectionTimeout : A duration that controls how long to wait before abandoning an attempt to make a connection to the server. The default value is 15 seconds.

Reference:

https://docs.microsoft.com/en-us/powerquery-m/odbc-datasource

Best Regards,
Community Support Team _ Zeon Zheng

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

[Abd]

Thanks for the reply @v-angzheng-msft ,

Forgot to mentioned that I already tried timeout but here the issue is the port where Power BI trying to query; its trying on restricted port so is there any way I can mention port no while trying to get data?
Also FYI I cant use ODBC due to compliance issues.

Regards,
Abd