Forum Discussion

Shalaka1's avatar
Shalaka1
Regular Visitor
4 years ago

OLE DB or ODBC error :[DataSource.Error] PostgreSQL: Exception while reading from stream .

We have a PostgreSQL database  which we have built a Power BI report. we are using direct query mode. Some of visuals are worked fine . I used 123 card in visual to show some data, At that time data ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Shalaka1 ,

 

Here are some things you can try:

Go to Edit Queries->Advanced Editor-> add timeout in the connection.

Source = PostgreSQL.Database("server_name", "database_name", [CommandTimeout=#duration(5, 0, 0, 0)]),

Refer to:

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

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.