Forum Discussion
problem connecting Azure DB PostgreSQL: Details: "PostgreSQL: Exception while reading from stream"
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
it seems not work..
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 _ Janeyyes i cleared permission and the problem remained
i am trying to connect with odbc, but not worked yet..
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