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

[Shalaka1]

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.

[Anonymous]

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.

[Shalaka1]

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)

[amitchandak]

@Shalaka1 , can you share calculation of measure used