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

  • ericspletzer's avatar
    ericspletzer
    Helper I
    2 years ago

    I am having this same issue.  Is there any word?

    It renders a lot of our financial reporting very difficult to use.

     

    • nickdc1's avatar
      nickdc1
      New Member
      2 years ago

      I have been having this issue, and using the information here have managed to work around it using a local gateway.

       

      The issue is specifically connected to creating new QuickBooksOnline connections in the cloud. This connector still works fine in Power BI Desktop, and if you are using the (I think previous) QuickBooks (rather than QuickBooksOnline) connector - which can connect to QuickBooks Online - that still works in the cloud too.

       

      To get this to work, I installed an on premise gateway and then created a new QuickBooksOnline connection with it. While this was successful, I now got a new error while refreshing the dataset I'd assigned this connection to.

       

      To resolve this, I changed one of the Gateway options to allow "Allow user's cloud data sources to refresh through the gateway cluster" and this now seems to work fine. 

       

      It is unclear why this connector has broken and whether it's a Microsoft or Intuit issue. It makes me rather concerned, as if the local connector option breaks then we're out of options for syncing this financial data.