Forum Discussion
Helper IVSet 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.
Helper IVThank 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.
Community SupportHi 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 Community
Solved: 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.
- AJAJ
Thanks v-veshwara-msft
dsn=Netsuite works.