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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

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.