Experiencing Time Out Error connecting to postgres database using npgsql on the server.

[Harsheclf]

Getting timed out error for any data source type while creating a new data source on on-premises gateway.. 

On-premises gateway app is running properly.

Below is the error :

Unable to create data source. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.

Details: OnPrimise_Powerbi_Gateway: We're sorry, an error occurred during evaluation. Please have this information handy if you choose to create a support ticket. ActivityId: 3aa3b654-fb53-4ed3-81e7-c6e77f4c3e07 RequestId: 70cf2493-37ec-40ce-825a-a2bcf573ebfa Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Sep 14 2022 11:29:02 GMT+0530 (India Standard Time)

[v-cazheng-msft]

Hi @Harsheclf,

Are you using the latest version of gateway and make sure it’s online? Did you see connection issue for other data sources registered on this gateway? To connect to the PostgreSQL, could you please try the PostgreSQL connector provided by Power BI and follow the guidance in this official document: Power Query PostgreSQL connector - Power Query | Microsoft Docs?

Best Regards,    

Community Support Team _ Caiyun

[Harsheclf]

Yes, latest version of gateway is used and it is online.

Yes, connection issues with other data sources too.

Yes, Connecting through PostgreSQL connector.

[ABI_Rufino]

Same problem here, latest version for gateway.

Gateway works fine to connect to folder, in example.

When creating a connection using PostgreSQL connector from PBI service I get the same error.