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 is not render and I got OLE DB or ODBC error :[DataSource.Error] PostgreSQL: Exception while reading from stream . error. Only for Card visual.

 

Need Help

3 Replies

  • Shalaka1's avatar
    Shalaka1
    Regular Visitor
    4 years ago

    Following are the measure calculation : 

    Store On Hand percentage change = divide([Store  On Hand ]-[Store On Hand Last Year ],[Store On Hand Last Year ],0)
  • 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.