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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

DataSource. Error

I have some reports that use the Quickbooks connector. In the last few days... I have been getting a Data Source Error when loading the data. I have been unable to find the solution in any forums even though I have seen others in the past with the issue. 

 

This is the error I am getting for two different Tables: 

 

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][DSI] (20030) Memory management error.
Details:
DataSourceKind=QuickBooksOnline
DataSourcePath=QuickBooksOnline
OdbcErrors=[Table]

 

This error is happening only on the "Attachable" and "Invoice_Sales_Item_Line" tables from the Quickbooks connector. I have attached a picture of the error along with a picture of my Data Load settings as I have seen it mentioned before in regards to this issue.

I would greatly appreciate any help in fixing this issue and understanding why it occured to prevent the issue in the future.

 

Data_Settings.PNGQuery_Error.PNG

 

4 REPLIES 4
johnyarbi
New Member

I found a solution that worked for me and posted the details in another thread:

 

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

v-kkf-msft
Community Support
Community Support

Hi @Anonymous ,

 

If you reduce the amount of data imported, does it still report the same error?


And please check your diagnostic logs to see if you can find the exact cause of the error.

Power BI Desktop diagnostics collection 

 

 

Best Regards,
Winniz

Anonymous
Not applicable

It seems so. I tried importing only one table, "Attachable" and it had the same error. That table shouldnt have too much data itself. Our datasets in general is quite small still being a newer company. 

 

I ran the diagnostic but was not seeing a file directed towards the error. Pic below shows what files are in the log. 

 

Capture.PNG

Were you able to solve the problem? I'm in the same situation

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors