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.

DataSource.Error when connecting to Quickbooks

Hi,

 

I am receiving the following error while trying to connect to invoice_sales_item_line table and deposit_line tables in Quickbooks through PowerBI desktop. The error pops up in powerquery while trying to preview the data.

 

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][DSI] (20030)

Memory management error.
Details:
DataSourceKind=QuickBooksOnline
DataSourcePath=QuickBooksOnline
OdbcErrors=[Table]

Status: New
Comments
v-yuta-msft
Community Support

@conorodocr ,

 

Does the data cache exceed the maximum allowed?

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ktjornhed
Regular Visitor

In My case it have not exceed the maximum allowed?

And i only get it in som tabels. example Invoice_Sales_Item_Line.

 

//Kim