problem connecting Azure DB PostgreSQL: Details: "PostgreSQL: Exception while reading from stream"

[maxianren]

i have some connection problem with Azure PostgreSQL database,

some people mentioned here to add Command Timeout but dosen't work for me

Solved: Postgresql: Exception while reading from stream - Microsoft Power BI Community

is there anyone can help? thank you

[v-janeyg-msft]

Hi, @maxianren 

The issue seems more to be with the PostgreSQL driver itself getting time out on read.

Try this method:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[maxianren]

it seems not work..

[v-janeyg-msft]

Hi, @maxianren 

First you can try to clear permission and connect again,

Check other ways to connect to PBI: 

PostgreSQL To Power BI: 3 Best Ways To Connect - Learn | Hevo (hevodata.com)

A similar solved thread:Solved: Azure PostgreSQL Direct Query? - Microsoft Power BI Community

Configure TLS connectivity in Azure Database for PostgreSQL

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[maxianren]

yes i cleared permission and the problem remained

i am trying to connect with odbc, but not worked yet..

[v-janeyg-msft]

Hi, @maxianren 

I was wrong, 0 can't be entered.

About your error:

This can happen because of a firewall or other server-side configuration which stops data from streaming. The Azure PostgreSQL server needs to be inspected for firewall settings to ensure that it allows incoming calls originating from the PowerBI Service.

This can also be the result of a timeout - which might also cause the server to "forcibly close" the connection. Check the timeout settings on the server and perhaps increase that timeout to a value that will allow the query to complete.

A similar thread:

Solved: a problem connecting wiht postgresql database - Microsoft Power BI Community

Using odbc to configure the cloud Azure PostgreSQL database requires other settings, you can refer to the tutorial I shared before.

Best Regards,
Community Support Team _ Janey

[amitchandak]

@maxianren , there are 3-4 steps , please make sure all are taken care. Driver SSL, certificate etc

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/

[maxianren]

thanks amitchandak

it seems that the method metioned in your post works well for AWS, but for azure, how to download the public key and convert to certificate? i still don't understand SSH setting?