OdbcErrors SQL0445W Value "2602 " has been truncated

[NilR]

Any one knows why I get below error with PBI Desktop when I run my query but not in Toad?

DataSource.Error: ODBC: SUCCESS_WITH_INFO [01004] [IBM][CLI Driver][DB2/AIX64] SQL0445W Value "2602 " has been truncated. SQLSTATE=01004

Details:
DataSourceKind=Odbc
OdbcErrors=[Table]

[v-eqin-msft · Accepted solution]

Hi @NilR ,

It may caused by the large table/data . Please try to optimize the data model to reduce the data size, like remove unnecessary columns, remove deplicate rows...

For more information, please refer to:

Optimization guide for Power BI - Power BI | Microsoft Docs

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

[v-eqin-msft · Accepted solution]

Hi @NilR ,

It may caused by the large table/data . Please try to optimize the data model to reduce the data size, like remove unnecessary columns, remove deplicate rows...

For more information, please refer to:

Optimization guide for Power BI - Power BI | Microsoft Docs

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

[NilR · Accepted solution]

I realized some of my columns have null and it throw exception unless I clean up the data and convert them all to something like string. so, I did COALESCE([field],"NULL")  and this fixed the error. not sure if it is a good solution but it fixed mine.