Forum Discussion
Set up Fabric Netsuite ODBC
Hi AJAJ ,
Thanks for sharing the details and the error screenshots.
From the message it seems to be related to the ODBC connection through the gateway.
In similar cases, a few steps have helped:
>>Try updating the connection string by replacing it with dsn=... and check if that works.
>>If not, there have been situations where the issue was resolved by changing the Windows account used by the Power BI Gateway.
Solved: Re: Adding ODBC connection in Power BI service fai... - Microsoft Fabric Community
The documentation on changing the service account is here: Change the on-premises data gateway service account | Microsoft Learn.
>>Another point to confirm is that the same authentication method is being used when creating the ODBC data source and when adding it under the gateway.
>>If the issue still persists, you can try reinstalling the ODBC driver and also reinstalling the latest gateway to see if that resolves it.
Similar dicsussions:
Solved: Connecting to ODBC Via Data Gateway - Microsoft Fabric CommunitySolved: Re: ODBC Connection Error - Driver Error - Microsoft Fabric Community
Solved: Re: Personal Gateway X On Premises Gateway - Microsoft Fabric Community
Please check if these steps help, and reach out for any further assistance.
Thank you.
Hi AJAJ ,
Thanks for posting your question in the Fabric Community.
At this point there is no direct connector to connect Fabric to NetSuite via ODBC without using a gateway. The approach that works in ADF with a self-hosted IR corresponds in Fabric to the on-premises data gateway, where the NetSuite ODBC driver needs to be installed.
Here is a link with a step-by-step process to pull data from NetSuite through ODBC in Dataflow Gen2: Solved: Re: Connecting NetSuite to Microsoft Fabric Lakeho... - Microsoft Fabric Community
There are a couple of related discussions you may want to review:
Fabric also supports virtual network data gateways. They can be used in Dataflow Gen2, and Data Pipelines depending on your network setup. You can review the details here: Use virtual network data gateways with Dataflow Gen2 and Use virtual network data gateways with Data Pipelines.
If avoiding an on-premises gateway is a requirement, another option is connecting through NetSuite REST or SOAP APIs using Dataflow Gen2.
Here is another similar discussions on methods connecting to Netsuite:
Solved: Netsuite to Power BI live feed - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
Thank you. I followed and got it to work partially.
ODBC works good.
Gateway software works good.
Fabric gateway status says online.
But connection errors out.
Hi AJAJ ,
Thanks for sharing the details and the error screenshots.
From the message it seems to be related to the ODBC connection through the gateway.
In similar cases, a few steps have helped:
>>Try updating the connection string by replacing it with dsn=... and check if that works.
>>If not, there have been situations where the issue was resolved by changing the Windows account used by the Power BI Gateway.
Solved: Re: Adding ODBC connection in Power BI service fai... - Microsoft Fabric Community
The documentation on changing the service account is here: Change the on-premises data gateway service account | Microsoft Learn.
>>Another point to confirm is that the same authentication method is being used when creating the ODBC data source and when adding it under the gateway.
>>If the issue still persists, you can try reinstalling the ODBC driver and also reinstalling the latest gateway to see if that resolves it.
Similar dicsussions:
Solved: Connecting to ODBC Via Data Gateway - Microsoft Fabric CommunitySolved: Re: ODBC Connection Error - Driver Error - Microsoft Fabric Community
Solved: Re: Personal Gateway X On Premises Gateway - Microsoft Fabric Community
Please check if these steps help, and reach out for any further assistance.
Thank you.
Thanks v-veshwara-msft
dsn=Netsuite works.