Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Quickbooks Online Refresh Error

Started receiving the below connection error when refreshing data from Quickbooks Online to the PowerBI service on 6/21/2021.  Haven't had any issues connecting in the past and am using the standard QBO-PowerBI connector.  Anyone else having problems as well?  Thanks!

 

Data source error: Web.Contents failed to get contents from 'https://quickbooks.api.intuit.com/v3/company/9130346898648726/query?query=SELECT%20Id%2CName%2CSubCl...' (400): Bad Request. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 078ad742-fd34-430e-8f3d-72b48c6090bb
Request ID: 0cf1c374-2a61-f39a-2c24-86dba4ddecaa
Time: 2021-06-25 11:58:10Z

Status: New
Comments
bmaupin
Frequent Visitor

@brianchannyc 

 

That looks like the newer PowerBI/QuickBooks connection, my connection is older and uses different tables.  Did you try to search for the class fields?  You may also be able to directly refresh your data in Desktop which could fix the problem without needing to delete any fields.