Forum Discussion
Helper Ipostgresql on azure connection time out
I have numerous tables which I can access on a VM in power bi desktop via postgresql on azure method, however when I try to access these tables on my local machine the operation times out (I have increased the wait time to 2 minutes however it fails a lot earlier than that).
Any clues as to why this might be happening given it all works on the VM just fine?
Tony
3 Replies
- amitchandak
Super User
Tony_Kuiper , first of all, check that you are able to access PostgreSQL using PgAdmin
Make sure all steps are followed
postgresql
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
https://niftit.com/connecting-power-bi-to-postgresql/Also check these
Tony_KuiperI cannot connect using my local machine but I can using the VM once again. I can get the tables using odbc but this is not what I need for the future of this report and dataset.
Again this seems odd because the VM works using the built in postgres on azure connector (the blue one). I can't see why I would need third party tools and gateways on a local machine and nothing on the VM.
- Tony_Kuiper
The saga goes on... I was reading up here https://www.sqlshack.com/accessing-azure-database-for-postgresql-using-pgadmin/ as it was quite thorough...
Again within the VM I can access the server but on my local machine (using a VPN) I cannot. Perhaps the "Allow Azure" in the networking security section of the postgresql service?
What is the effect of changing to azure plus postgresql access? does it change the credentials requirements?
