I'm logged into quickbooks online on Power BI desktop just fine and everything refreshes. I published it to my workspace and went to set an autorefresh and it asked me to log into QBO. I logged in but then I get this error message. It's the same credentials from the desktop. Does anyone know how to fix this? Thanks! Failed to update data source credentials: ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failedHide detailsActivity ID:1c8e67db-60c0-4056-90f5-3efe6e5afa5cRequest ID:4601c7a8-e9be-cec4-4eb5-36e26c348c64Status code:400Time:Fri Mar 01 2024 17:46:48 GMT-0500 (Eastern Standard Time)Service version:13.0.22729.74Client version:2402.3.18145-trainCluster URI:https://wabi-us-north-central-b-redirect.analysis.windows.net/

Hi fhovey , This issue has been confirmed as a known issue internally. Please be patient to wait for fixing. If there is any news, I will update it here. Best Regards,YangCommunity Support Team

This is still an unresolved issue. It has been over a month. Do we have any updates? Anonymous ?fhovey - Please mark this conversation as unresolved as Yang's comment is not a solution. The on-premise gateway suggestion is a bad workaround and should not be suggested. The community needs to come together to rise these important bugs up to Microsoft. Here are my error details:- I can confirm the connection to QBO works still using Power BI Desktop. - I have deleted the existing dataset in Power BI Service and re-published under a different dataset name to see if that would help, it did not. - I have tried multiple variations of selecting (None, Private, Public, Organizational under OAuth Connection Settings and they all do not work) Failed to update data source credentials: ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failedquickbooks Quickbookpro Quickbooksorg Maybe you can help here?

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.

It doesn't give me the option to select basic auth

I've had this issue the 1st too. Still unresolved!

Quickbooks Online credentials | Microsoft Fabric Community

Forum Discussion

31 Replies

Related content