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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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.