Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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

Submitted by Anonymous on ‎09-13-2022 11:03 PM

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.

MicrosoftTeams-image (1).png

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)

Status: Investigating

Hi @Anonymous,

 

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

See more ideas labeled with:
3 Comments (3 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎09-14-2022 07:09 PM
Status changed to: Investigating

Hi @Anonymous,

 

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

Anonymous
Not applicable
‎09-15-2022 02:10 AM

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
Advocate I
Advocate I
‎10-02-2023 11:17 AM

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.

Idea Statuses