Forum Discussion
Issue connecting through a gateway
I have a PowerBI Gateway setup and registered just fine. I have the Gateway configured in the powerBI service and it is OK. I can connect to the database (Postgresql) from the gateway server using pgAdmin. When trying to connect to the configured database I run into a timeout.
Where can I start to troubleshoot this? In the exported logs I couldnt find anything, but maybe I wasnt looking in the correct files.
2 Replies
Hi wolfgangkb-work -Open the Power BI Gateway app on the server.Run the Network Port Test available in the diagnostics section. This can identify any blocked ports or configuration issues preventing connectivity.
Can you please follow the below reference document. Hope it supports
Check PostgreSQL server logs to identify if any connections are attempted but not completed
C:\Program Files\PostgreSQL\<version>\data\pg_log on Windows installations.
Troubleshoot gateways - Power BI | Microsoft Learn
Manage an on-premises data gateway | Microsoft Learn
https://community.powerbi.com/t5/Desktop/Gateway-Timeout-Error/td-p/1588932
- From the Gateway server, run ping [your_database_host] to ensure it’s reachable.
- Use the "Test Connection" button in the Power BI service under the data source settings to verify connectivity.
- If the default connection timeout is too short, consider adjusting the connection string in the data source settings. You can add Timeout=120 (or higher) to the connection string to allow for longer connections.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
