Getting issue with Quickbooks online, while importing tables from Quickbooks online to Power bi.

[Manoj_Kumar]

Hi Community Members,

After importing the data that has negative values in Quickbooks online coming as positive values in power bi tables.
Ex : Below screenshot from quickbooks online report which has negetive values

The same values are coming as positive values after importing data to power bi via quickbooks connector.

I don't see any specific column that indicates Debit/Credit amount values.

This is impacting the fundamental calculations of the report. Since the data is huge I cannot even flag the values +ve/-ve manually. Even tried using DataSource=QuickBooks.Tables() instead of DataSource=QuickBooksOnline.Tables()

I really need your inputs in order to resolve the issues.
Thanks in advance!!

[foodd]

Question:  After successfully connecting to QuickBooks Online, and within the Navigator dialog box,

are you able to preview the table you are referring to, and is the value in the column matching your recollection?   The notion is to observe what values are present at the time of import, before any downstream transformations in the query.

Other support options for you include  Resource Center, Product Support

Also, encourage you to post and search within the Intuit Developer Site where there would be an audience for your question.