ODBC: SUCCESS_WITH_INFO [01004] [NetSuite][ODBC 64bit driver][OpenAccess]Data truncated

[crichards]

Data from NetSuite trying to add an ODBC table 'MESSAGES' and receive an error 'Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: SUCCESS_WITH_INFO [01004] [NetSuite][ODBC 64bit driver][OpenAccess]Data truncated.'

looks like something is too long, how do i limit the entry to keep Power BI Desktop happy?

[v-ljerr-msft · Accepted solution]

Hi @crichards,

Based on my search, it seems to be that there is either a bug in this particular ODBC driver or a bug in the in Power BI ODBC connector. So I would suggest you try sending a frown(if possible) or create a support ticket on Power BI Support page for better assistance.

In addition, here is a similar idea for your reference. 

Regards

[crichards]

Thank you, apparently there is a known (NetSuite) issue with the NetSuite driver.. the temporary fix is to limit the data being returned to the Data Source.

[Anonymous]

I'm having the same error in 2020 when trying to pull a large amount of data...is that still the case?

[crichards]

would it possibly be a Time Out error from the ODBC, can i change this duration?