Forum Discussion
Quickbooks Online credentials
Any update from Microsoft on this issue? v-huijie-msft
Ideally, the Power BI QuickBooks Online connector could get fixed and be moved out of beta.
However, as a workaround I am trying to implement the on-premises data gateway solution.
As a test, I downloaded the gateway onto my laptop and was able to set up QuickBooks Online connections without issue.
For my client, we created a new VM in Azure running Windows Server Datacenter 2022 and installed the on-premises data gateway onto the new server with nothing else installed on the server.
The gateway installed fine, and all the Simba Quickbooks ODBC Driver files appear to be in order. The gateway also shows as Online in the Power BI Service.
Unfortunately, when I try setting up a new QuickBooks online connection, I get the usual ODBC error:
ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
What else needs to be installed on the server to get the gateway to run properly for the QuickBooks Online connection?
On my personal laptop, I have SQL Server 2022 installed and the ODBC Driver 17 for SQL Server. I tried installing both on the new server, but it did not help the gateway issue.
At this point, I cannot think of anything else to try. I am hoping to get some help from the Microsoft team?
Experiencing the same issue, I have had to log a ticket with Microsoft - Power Platform admin center; we are currently working through this issue with them.
I have a booking next week to continue the troubleshooting and they have given information that this is still an ongoing issue as other users in the powerbi community have also reported the issues as well and they are needing as much information as possible to put to QB to determine where the fault lies.
I feel like there is some kind of token auth time out issue in the cloud connector and this is possibly blocking the session as this is not an issue when the desktop client establishes a connection.
In case anyone is running into issues trying to use the on-premises data gateway solution, I figured out how to get the QBO connections to work.
I had a new server with Windows Server 2022 Datacenter running on it and was still getting the "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" error.After installing Visual Studio 2022 Community on the server I am now able to set up QBO connections on the gateway. I don't know exactly which component of VS resolved the issue, but figured I'd share.
