Forum Discussion

fhovey's avatar
fhovey
Advocate I
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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,
Yang
Community Support Team

sushiservice's avatar
sushiservice
New Member
2 years ago

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 failed

quickbooks Quickbookpro Quickbooksorg Maybe you can help here? 

  • DaveyL888's avatar
    DaveyL888
    New Member
    2 years ago

    Same issues on my end, online powerbi reporting refresh will not work but the desktop powerbi will work no problems. 

     

    And all the credentials are correct!

     

    Failed to update data source credentials: ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed