KNOWLEDGE BASE

Error "InsertData: multiple entries for column [Line Item Based Expense Detail MarkupInfo PriceLevel Ref Value]" Joining Quickbooks Online Tables


Published: 19 Jul 2019
Last Modified Date: 22 Jul 2019

Issue

When joining certain tables to "Sales and Line Item Expense Details" in QuickBooks Online connections, an error occurs:
InsertData: multiple entries for column [Line Item Based Expense Detail MarkupInfo PriceLevel Ref Value]"

This can happen when joining the following tables to the "Sales and Line Item Expense Details" table:

  • Bills
  • Purchases
  • Purchase Order
  • Vendor Credit

Environment

  • Tableau Desktop 2019.1 - 2019.2
  • QuickBooks Online

Cause

This behavior is related to a known issue which is currently under investigation. 
Did this article resolve the issue?