Calculated column in the DB2 view through direct query gives the below error

[sccode_works]

Getting the following error when calculated column is added to the report. All these calculations are done in Db2 view. When calculated column is removed, the error disappears.

Couldn't load the data for this visual

OLE DB or ODBC error:[DataSource.Error] Microsoft Db2 Client: HISMPCB0001 in BasePrimitiveConverter an exception has occurred. Exception description: Non-negative number required.

Parameter name: count SQLSTATE=HY000 SQLCODE=-343

The calculated column used in the power BI report has non-negative values. 

Please help. 

[Anonymous]

Are you making a calculation in your SQL request ? like Multiplication (*) or Division (/) of numbers or decimals ? 

If it's the case, split it in two columns at request level and make the calculation in power BI with power Query 😉

I hope my answer helps.

[Anonymous]

Hi @sccode_works ,

Can you please share some dummy data that keep the raw data structure and dax expressions with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng