Quickbooks Online Fields missing

[Anonymous]

Good day,

I am struggling with the Quickbooks Online tables in Power BI desktop.  The relationships are not apparent and it appears that some field data is missing.  Many fields contain [Record] or [List] as data.  For example, Customer Ref in the invoice table shows [Record].

For example, invoice table:

Id

SyncToken

MetaData

CustomField

DocNumber

TxnDate

DepartmentRef

CurrencyRef

ExchangeRate

PrivateNote

LinkedTxn

Line

TxnTaxDetail

CustomerRef

12376

2

[Record]

[List]

INV001366

14-May-18

[Record]

1

[List]

[List]

[Record]

[Record]

Many thanksAssistance would be much appreciated.

Karen

[v-yulgu-msft]

Hi @Anonymous,

You can expand the [Record] and [List] to extract actual data from them.

Regards,

Yuliana Gu

[Anonymous]

Thanks Yuliana, I can do this for one record at a time.  How do I expand all of these items for use in the original table?