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

[conorodocr]

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]

[johnyarbi]

I realize this is an old topic but I ran into something similar and managed to find a solution that actually worked.  Another post (here) is what gave me the clue I needed.  The poster observed "when the text field is longer than x number of characters, I get the following error message" and it made me realize that was likely the cause.

I found the error was showing up in Power Query Editor but the table data actually loaded and I could create reports against it.  My table was actually SalesReceipt_Sales_Item_Line so I needed to find where the lengthy text was coming from.  There are several ways to do this but here is the quick and dirty method I used that finally got rid of the error.

I started with the Line_Description field and created a calculated column in the target table with DAX to find the length:

Line_Description_Lenth = LEN([Line_Description])

I also created another calculated column with DAX to form a link directly to the Sales Receipt to make things easy to edit:

Link_to_Sales_Receipt = CONCATENATE("https://app.qbo.intuit.com/app/salesreceipt?txnId=", [Id])

(note, you might need to swap out the link for your environment or specific transaction type, mine was 'salesreceipt')

Once the link column is created, click it, and go to the Column tools tab at the top in your ribbon.  Change the Data category to Web URL.

I then added a matrix visual to the canvas and dragged over the newly created Line_Description_Length as the first row, Link_to_Sales_Receipt as the second row, and Count of Id for the values.

Sort by Line_Description_Length in descending order and start opening the transactions to shorten the long text values.

In the end, I had 6 or so that were over 1000 due to long descriptions I had copied and pasted from a website for the product.  The max size in my list is now 844 and it loads as expected.  I went in and edited the descriptions of the items that were causing the issue to avoid running into it again in the future.

Here are some screenshots:

 Hope this helps someone!

[ericspletzer]

This worked for me.  One record over 1200 characters long.  Broke up and it started loading again.

[Anonymous]

Hi @conorodocr ,

I suggest you to create a support ticket for further analysis.

Best Regards,

Jay

[conorodocr]

Hi Jay,

Thanks for your response. I have a 365 license which I use for PowerBI Desktop. It doesn't appear to let me submit a ticket?

Thanks,

Conor

[Anonymous]

Hi @conorodocr ,

Please try CREATE SUPPORT TICKET -> Describe your issue -> CONTINUE TO SUPPORT TICKET -> fill out the ticket and click SUBMIT TICKET.

Pro users get free support, for more information about Power BI license, please check below document:

https://docs.microsoft.com/en-us/power-bi/service-admin-licensing-organization.

Best Regards,

Jay

Community Support Team _ Jay Wang

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