NetSuite ODBC truncation

[ebjim]

I am importing from NetSuite into a Dataflow gen2 via ODBC and got this error even before I could complete the Get data wziard:

Am I correct in saying that there is no way to resolve this in Fabric?

[v-nikhilan-msft]

Hi @ebjim 

Thanks for using Fabric Community.

Did you check this document on ODBC connections?

https://learn.microsoft.com/en-us/fabric/data-factory/connector-odbc

Are all the pre-requisites met?

Please check the supported types here

https://learn.microsoft.com/en-us/power-query/connectors/odbc#prerequisites

Hope this helps. If the issue still persists please do let me know.

[ebjim]

Yes, on both questions. I successfully imported other NetSuite tables.

[Jerr31]

Have you already tried on of the sollution on these pages? 

1. https://stackoverflow.com/questions/62223226/netsuite-odbc-limitations
2. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_1555594476.html#am-getting-tru...

[jerr]

How are you able to load directly netsuite data in Fabric, via a VM where the ODBC is installed? We would like to skip the VM part with the NetSuite driver, is that possible?

[v-nikhilan-msft]

Hi @ebjim 

Thanks for the details. So which tables are you facing the issue with?

Do these tables have huge amount of data?

[v-nikhilan-msft · Accepted solution]

Hi @ebjim 

As the issue is with only some tables,  I would request you to contact NetSuite support. They might have updated information on the driver's limitations or potential workarounds.

Hope this helps.