Power Bi Query Error using Quickbooks Connector - Truncation

Hi BRAGAIDAN ,

Thank you for reaching out to the Microsoft fabric community forum  regarding the issue you’re experiencing with the QuickBooks Online Connector in Power BI.

The error you’re encountering, which states that the Line_Description exceeds the maximum character limit during the table expansion, indicates that Power BI is unable to store the data without truncating it. This typically occurs because the data being pulled exceeds the configured limits.

To address the truncation issue efficiently, start by retrieving and expanding simpler or minimal columns. After confirming the structure and functionality of these fields, you can then explore solutions for the Line_Description error more effectively.

Here are the troubleshooting steps to address the issue:

• Firstly, rather than directly expanding the table, consider viewing the schema or metadata of the data beforehand. This can be achieved by loading a small sample of the data or previewing its structure using the appropriate methods for your data connector.
• When utilizing the QuickBooks Online connector, data is typically retrieved through a single query. To minimize issues, consider using any available options to limit or filter the data being pulled. For instance, if you have control over the query, you could reduce the dataset by applying certain conditions (if supported by the connector) to exclude records with lengthy descriptions from being loaded initially.
• If your connector supports writing more advanced queries or API calls, focus only on the specific fields you need, temporarily excluding the Line_Description. This approach allows you to expand a smaller subset of data initially without causing truncation.
• Try to load the Invoice_Sales_Item_Line table with only the essential fields that don’t include Line_Description first. This way, you isolate the table's primary structure without triggering the truncation error.

For more information please refer below documentation:

Power Query QuickBooks Online connector - Power Query | Microsoft Learn

If the issue persists after troubleshooting above steps, I suggest you raise a support ticket so they can assist in addressing the issue, please refer below link on how to raise a contact support or support ticket.

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Since this issue may also be related to how QuickBooks handles data exports, reaching out to QuickBooks support could provide additional insights or updates regarding any known issues with their API or data structure.

I hope these suggestions help you overcome the truncation issue while working with QuickBooks Online data in Power BI. If you have any further questions or require additional assistance, please feel free to reach out again.

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

Thank you.