cancel
Showing results for 
Search instead for 
Did you mean: 

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

Hi,

trying to user the Netsuite ODBC connector for Power BI Desktop and keep receiving this error, is there a setting that can be changed? how can i work around this error?

 

 

DataSource.Error: ODBC: SUCCESS_WITH_INFO [01004] [NetSuite][ODBC 64bit driver][OpenAccess]Data truncated
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=NetSuite
OdbcErrors=Table

Status: Needs Info
Comments
Moderator

Hi @crichards,

 

1. Please check if any detail error message logged in desktop trace log files? 

2. As you create a DSN in ODBC driver, please try to check if you can get data via ODBC in Excel file as well. 

3. Please try to run the latest Power BI desktop version 2.55.5010.521

 

Best Regards,
Qiuyun Yu 

Established Member
Status changed to: Needs Info
 
Frequent Visitor

thanks Qiunyun, i have tried the ODBC through MS Access and and has simular issue. can get it to work if i filter the table that is being read before it gets used.. have reported to Netsuite and it is a Known issue.

 

have installed the latest version 02Feb2018 for Desktop.

 

think my option is to create an SQL query on the Data Source to filter on EVENT_ID !="", just trying to get my head around how to address the the table in NetSuite.

 

 

Moderator

Hi @crichards,

 

From your description, it seems not only the issue happens on Power BI side. The issue should be related to Netsuit ODBC driver. I would suggest you contact Netsuit to update driver. 

 

Best Regards,
Qiuyun Yu 

Frequent Visitor

Correct Qiuyun, It is a driver issue that NetSuite is in no hurry to fix.