Forum Discussion
Quickbooks Online credentials
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 bu...
It is July and I am experiencing the exact same problem. Works when I refresh from desktop BI, I can successfully update my credentials by signing into quickbooks but get the error : Failed to update data source credentials: ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
Is there a solution that is not the on-premise gateway workaround yet?
FYI - The on-premises gateway workaround is very unreliable. It appears the issue is on the QuickBooks side, but refreshes are very inconsistent. The same semantic model can take 2 minutes to refresh on one day, then spin for 2 hours and time out the next day. Unfortunately, we may need to go the API route for our QB data.
