Forum Discussion
Advocate IQuickbooks 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?
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.
Following up on this for anyone who lands here from a search: the native QuickBooks Online connector was never fixed for scheduled refresh in the Service and has since been deprecated, so the on-prem gateway route isn’t a long-term answer either.
We ended up going the API route as I mentioned above, and I turned it into a product: DataToLake (https://www.datatolake.com). Full disclosure, it’s my company. It connects to QBO through Intuit’s official APIs, syncs the entities you pick on an hourly or daily schedule into managed Azure Data Lake Storage, and includes a Power BI template. You don’t need your own Azure subscription or a gateway, and scheduled refresh in the Service works normally. There’s a 14-day free trial if anyone wants to test it against their own company file.
Happy to answer questions here if anyone is still fighting this.